Index & Match Possibly??

[clumpa]

I have a workbook with 1 sheet containing names in col.1 nd scores in another col.

A 2nd sheet in the same workbook has the same names in a different order and I want to add the correct score adjacent to the name on the 2nd sheet

I am a part-time Excel user@@

 

[Faseeh]

Hi clumpa,

You can use INDEX(Sheet1ColB,MATCH(Sheet2ColA,Sheet1ColA,0))

..here

Sheet1ColB = Sheet 2 Col B that contains scores,
Sheet2ColA= Refers to the cell in Sheet B for which value is to be retrived,
Sheet1ColA= is the column where the value will be looked in i.e. Col B of sheet1.

 

[Somendra Misra]

Hi clumpa,

Doesn't VLOOKUP meet this requirement, if the names are unique?

Regards,

 

[clumpa]

Hi clumpa,

Doesn't VLOOKUP meet this requirement, if the names are unique?

Regards,

 

[clumpa]

Yes it does, thanks