MCQs>Finance & Management>Excel>Which formula should be used to find the row that 'Steven' appears in and return his phone number? (Sheet contains Names in Column A and Phone Numbers in Column B)
Excel MCQs
Which formula should be used to find the row that "Steven" appears in and return his phone number? (Sheet contains Names in Column A and Phone Numbers in Column B)
Answer
Correct Answer: =VLOOKUP("Steven",A:B,2,FALSE)
Explanation:
Note: This Question is unanswered, help us to find answer for this one