| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling info referencing another column | Excel Discussion (Misc queries) | |||
| Pulling Info | Excel Discussion (Misc queries) | |||
| Pulling info from a list | Excel Worksheet Functions | |||
| Using a date range in a formula to pull info to the correct column | Excel Worksheet Functions | |||
| Pulling info into another sheet | Excel Worksheet Functions | |||
Linear Mode
