Get the most out of your questions with IDNLearn.com's extensive resources. Ask your questions and receive detailed and reliable answers from our experienced and knowledgeable community members.
Put a VLOOKUP function in cell C5 to show the very first pupil's rings price. VLOOKUP is your response (B5,A16:B19,2,FALSE) The lookup value is B5, the table array is A16:B19.
The column index number is 2, and FALSE denotes an exact match. I would suggest changing the vloopup function if you want to drag for all of the cells below.
How is a VLOOKUP inserted?
Enter =VLOOKUP in the Formula Bar ().
Enter your lookup value in the parenthesis, then a comma.
the price point of data you wish to search, your table array or lookup table, and a comma: Enter the tab index value (H2, B3:F25).
Type TRUE or FALSE as the range lookup value.
To know more about VLOOKUP click here
brainly.com/question/18137077
#SPJ4