VLOOKUP example not working...
Yes. See item 1. in my list
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"steph44haf" wrote in message ...
|I think the issue may be with the table. The data we are looking up may be
| 26754, but the lookup table reference has the number as '26754. Is there any
| way to fix this?
|
| "steph44haf" wrote:
|
| 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
|