Forum Discussion
Solved
Index Match 3 columns
Hi all, I have three columns of data. I3:I450 have values in that occur multiple times. These are the same as values in R3:R61 - in this column they only occur once each. Simultaneously, S3:...
In another cell in row 3, for example J3:
=VLOOKUP(I3, $R$3:$S$61, 2, FALSE)
or
=XLOOKUP(I3, $R$3:$R$61, $S$3:$S$61)
Fill down to row 450.
In another cell in row 3, for example J3:
=VLOOKUP(I3, $R$3:$S$61, 2, FALSE)
or
=XLOOKUP(I3, $R$3:$R$61, $S$3:$S$61)
Fill down to row 450.
- Hi Hans,
Thank you so much for your reply.
I think the XLOOKUP is the preferred solution. At the moment though I get N/A, although the data does exist. I've checked the formats and they're both the same (number). Are there any other common troubleshooting I can do?Check whether there are spaces before or after the values that should match but don't.
Hi Hans,
no spaces but no luck.I had different decimal places, this has been resolved now. Thanks!
Many thanks,
Alfie
