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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - my vlook up is not pulling the correct info from column 2 (https://www.excelbanter.com/excel-worksheet-functions/242987-my-vlook-up-not-pulling-correct-info-column-2-a.html)

highonmtn

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

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[_2_]

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

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"highonmtn" wrote in message
...
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

All times are GMT +1. The time now is 01:11 AM.