Question

What function is used to search for a value in the first column of a table array and returns a value in the same row from another column in the table array?
A. AND

B. SUM

C. IF

D. Vlookup

Answer 1

the answer was vlookup.

Answer 2

In spreadsheets such as Excel you can use VLOOKUP to find a specified item in eg column 1 and return a value which is in this same row but column 2 (or whatever). DNSLookup works in a similar sort of fashion