| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP example not working...
Column A =IF('PM & PDA Use-PO Data Entry'!B3=0," ",'PM & PDA Use-PO Data
Entry'!B3) Column B =VLOOKUP(A1,Sheet2!$A$1:$B$17000,2,FALSE) If Column A = 16354-XL, Column B gives correct description ex "Gloves" If Column A = 26754, Column B can't find match and gives "#N/A" If we type in 26754 (instead of formula) in Column A, Column B gives correct desctiption ex "Hats" Thanks, Steph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup formula not working with data on separate sheet | Excel Worksheet Functions | |||
| Vlookup not working because of duplicate matches | Excel Worksheet Functions | |||
| Vlookup not working in 2000 - worked in 97! | Excel Discussion (Misc queries) | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
Threaded Mode
