Thread: my vlook up is not pulling the correct info from column 2
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default 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

Reply With QuoteReply With Quote