Vlookup not working

HI Everyone ,

Im working on 2 excelsheets .Im using VLOOKUP formula to fetch the details from one of the sheets , but my formula is giving me error (#REF).
What would be the issue?
Could you please see why my VLOOKUP FORMULA IS NOT WORKING ?

Im using the below Formula,

=VLOOKUP(A2,Sheet2!$A$1:$N$102,10,FALSE)
I need to populate the 10th column of sheet 2 in sheet 1

#REF is the result im getting

Attachment

Firstly your formula is slightly incorrect. THe 2nd argument needs to start on the column you're looking for the value in. In your sample workbook this should be C not A.
=VLOOKUP(A2,Sheet2!$C$1:$J$11,8,0)

Secondly, on Sheet1 there is a double space before the hyphen and on Sheet2 it's only a single space.

Fix those two things and it should work.

BSB

If you cannot change the double space for any reason then you could use this formula

=VLOOKUP(SUBSTITUTE(A2," "," "),Sheet2!$C$1:$J$11,8,0)

BSB

Thank you , Sir ! It worked ..

No problem at all. Happy to help

BSB