trouble with vlookup

  • Thread starter Thread starter Stuart K
  • Start date Start date
S

Stuart K

hi

wondering if anyone can help with a vlookup function

i am trying to build a sheet that will pull product
informtion from a spreadsheet
Col A Col B Col C
1 Product Description Cost
2 3600 Lightweight Folding Square Table £48.95
3 1001B VL C-Leg Ergo Desk Left £103.70
4 1001C VL C-Leg Ergo Desk Left 152W £103.70

using
=VLOOKUP(A2,A1:J9457,2,FALSE) i am trying to get the
description when i enter the product

when i type in 3600 i get the correct result
when i type in 1001B i get N/A

however if i copy and paste 1001B into the lookup cell i
get the correct result

any help would be grateful

thanks

stuart
 
1001B is considered text so use "1001B"

--
Don Guillett
SalesAid Software
(e-mail address removed)
hi

wondering if anyone can help with a vlookup function

i am trying to build a sheet that will pull product
informtion from a spreadsheet
Col A Col B Col C
1 Product Description Cost
2 3600 Lightweight Folding Square Table £48.95
3 1001B VL C-Leg Ergo Desk Left £103.70
4 1001C VL C-Leg Ergo Desk Left 152W £103.70

using
=VLOOKUP(A2,A1:J9457,2,FALSE) i am trying to get the
description when i enter the product

when i type in 3600 i get the correct result
when i type in 1001B i get N/A

however if i copy and paste 1001B into the lookup cell i
get the correct result

any help would be grateful

thanks

stuart
 
Stuart
Are you sure the zeros are zeros, and not O's? Also, are there any spaces before or after the text? When working with numbers you do have to be sure that they are not formated as text, but since you have a B in your value that shouldn't be causing a problem

Is this the actual formula you are using? If so the your lookup value is located inside your table array. Also your column descriptors are part of your table array

On a side note, one time saver for VLOOKUP is to use a zero instead of FALSE

Good Luck
Mark Graesse
(e-mail address removed)

----- Stuart K wrote: ----

h

wondering if anyone can help with a vlookup functio

i am trying to build a sheet that will pull product
informtion from a spreadshee
Col A Col B Col
1 Product Description Cos
2 3600 Lightweight Folding Square Table £48.9
3 1001B VL C-Leg Ergo Desk Left £103.7
4 1001C VL C-Leg Ergo Desk Left 152W £103.7

usin
=VLOOKUP(A2,A1:J9457,2,FALSE) i am trying to get the
description when i enter the produc

when i type in 3600 i get the correct resul
when i type in 1001B i get N/

however if i copy and paste 1001B into the lookup cell i
get the correct resul

any help would be gratefu

thank

stuar
 
glad to help

--
Don Guillett
SalesAid Software
(e-mail address removed)
Thanks

this seems to have worked

s
 
Back
Top