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)
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)
PewPewProject Thank you!! The XLookup equation worked!