Forum Discussion
Solved
VLOOKUP Issue
Hi, My apologies as this is a very basic VLOOKUP question but I can't figure it out. I have data where every person has a research partner. I'm trying to create a Partner_ID variable that contai...
Hi jtrick
The two options I've found are either change the order of your columns so that the lookup value (PartnerLast) is in the first column in the range https://support.microsoft.com/en-au/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1).
Alternatively, you can use XLOOKUP:
Formula used: =XLOOKUP(C2,$B$2:$B$7,$A$2:$A$7)
jtrick Alternatively, if your Excel does not have XLOOKUP and you are not able/allowed to change the order of the columns you could try this: