my vlook up is not pulling the correct info from column 2

[highonmtn]

simple formula not pulling correct info
=VLOOKUP($B8,Table13,2)

RR-01 (B8) should be "Roller" (from column 2)
instead it is pulling the next line down

 

[Ashish Mathur]

Hi,

Try =VLOOKUP($B8,Table13,2,0)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com