Create and copy a VLOOKUP function to display goals for each funding source.

a$.$ Click the Family Day sheet tab and select cell F$6.$

b$.$ Start the VLOOKUP function and use cell E$6$ as the lookup$\_$value.

c$.$ Click the Tables sheet tab for the tabie$\_$array argument and use cells SAS$6$:SBS$10.$ The data is sorted by the first column in ascending order.

Figure $2-127$ bats format sol

d$.$ Use the second column as the col$\_$index$\_$num The range$\_$lookup argument is empty.

e$.$ Copy the formula in cell F$6$ to cells F$7$:F$20$ without formatting to preserve the fill coicr.

Format cellis F$6$:F$20$ as Currency with no decimal places.