Forum Discussion
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:S61 have an ID value that runs concurrently to R3:R61.
I need a formula that indexes S3:S61 IF the values in I the same as in R. So, if I3 matches R3, index S3 as an example or if I300 matches R40, index R40.
I hope that makes sense.
Cheers,
Alfie
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.
4 Replies
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.
