Vlookup-problem Doesn't Return Some Values?

  • Thread starter Thread starter ginnawatts
  • Start date Start date
G

ginnawatts

I am trying to create a quote form where I just have to enter a code an
it will return a product description and price. I have the products i
a table in another worksheet, and I have used this formula...
=IF(ISBLANK(B10)," ",VLOOKUP(B10,INVTRY!A2:C47,2,FALSE))

And this works for many of the numbers but not for others. Example if
type in 2418 it returns the description but if I type 2408 or 249258 i
just returns #NA but the information is in the table.

I have tried everything changing my cell references to absolute
sorting numerically, adding other values to change my lowest number
etc. Is there anything you can suggest?

I would like to be able to use numbers and letters for my item #'s o
codes to recall product information.

Any suggestions?

Ginna

:confused
 
Hi
this is probably caused by some formating issues. are you sure the
numbers in your lookup tables are stored as numbers (and not as
'Text'). check the value which should match (e.g. INVTRY!A10) with
something like
=B10=INVTRY!A10
this should return TRUE
also check
=ISNUMBER(INVTRY!A10)
and
=ISNUMBER(B10)

both should also return TRUE
 
Back
Top