VLOOKUP returns value from different row.

[crazyaboutgus]

This driving me mad. I want the A column to find it's match in the G column and place the corresponding number from the H column in the the B column. Please see attachment.

formula is so basic: =VLOOKUP($A2,G1:H8806,2)

Thank you for your help in advance.

[Richard Buttrey]

Hi,

You'll need to remove the trailing spaces from the values in column G.
Then using a belt and braces approach use FALSE as the fourth element of the VLOOKUP() and fix the lookup range with $. i.e.

Please Login or Register  to view this content.

[crazyaboutgus]

Holy Smokes! I didn't even thing of the extra spaces. Is that why it took the number above it? Thank you so much!