Forum Discussion

Alfieb1996's avatar
Alfieb1996
Brass Contributor
Dec 13, 2022
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:...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Dec 13, 2022

    Alfieb1996 

    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.

HansVogelaar's avatar
HansVogelaar
MVP
Dec 13, 2022

Alfieb1996 

Check whether there are spaces before or after the values that should match but don't.

Alfieb1996's avatar
Alfieb1996
Brass Contributor
Dec 13, 2022

Hi Hans,

no spaces but no luck. 

I had different decimal places, this has been resolved now. Thanks! 
Many thanks,

Alfie

Resources