trouble with vlookup

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
 
D

Don Guillett

1001B is considered text so use "1001B"

--
Don Guillett
SalesAid Software
[email protected]
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
 
M

Mark Graesser

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
[email protected]

----- 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
 
Top