Question: Excel - Use the formula builder to add a vLookup function to display the agent's office location on the MonthlySales table in Column Which of

Excel - Use the formula builder to add a vLookup function to display the agent's office location on the MonthlySales table in Column
Which of the following best matches the the correct function you should see in cell I5?
=VLOOKUP([@[Agent ID]],Table1[#All],2,TRUE)
=VLOOKUP([@[Carrier]],Table1[#All],2,TRUE)
=HLOOKUP([@[Agent ID]],Table1[#AII],2,TRUE)
=VLOOKUP([@[Agent ID]],Table1[#All],2,FALSE)
 Excel - Use the formula builder to add a vLookup function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!