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

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

anonymous · Answer

the answer was vlookup.

anonymous · Answer

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