Home » Excel Experts Quiz

Excel Experts Quiz

Question 1 of 13

You have the following data starting in A1, and want to enter "Nick" into a function, and return "100". Which of the following function calls will do this ?

Amount Name
10 Bob
100 Nick
1000 Lucy

 

=RVLOOKUP("Nick",A1:B4,1,FALSE)

=VLOOKUP("Nick",B1:B4,-1,FALSE)

=INDEX(A2:A4,MATCH("Nick",B2:B4,0),1)

=HLOOKUP("Nick",A1:B4,1,FALSE)

=INDEX(B2:B4,MATCH("Nick",A2:A4,0),1)