medium10 pts · first answer countsexcellookups

Looking up a value to the left

Your sheet has Name in column A and Employee ID in column D. You have an ID and need the name. Why does VLOOKUP struggle here, and what works?

A.VLOOKUP only searches the first column of its range and returns values to the right; INDEX/MATCH or XLOOKUP can return a column to the leftB.VLOOKUP cannot match numbers; convert IDs to textC.VLOOKUP needs the data sorted by name; sort column A firstD.VLOOKUP only works on one sheet at a time; move the data

Discussion 0

Join free to post in the discussion.

Looking up a value to the left

Discussion 0

Related questions