Problems with VLOOKUP

[Johosh]

I am trying to use the VLOOKUP function to auto-complete an order sheet with
product information.

I am using the following formula in the C4 cell:
=VLOOKUP(B4,'Product List'!$A$1:$D$100, 4, FALSE)

It is supposed to search the product number (in this case, "t25") and find
the cost of that product, located in column D.

I can't get this to work whatsoever, and just get a result of #N/A.

Some other examples of product numbers include:
t25
t26
t66
x90

....if that helps at all in diagnosing.

 

[Sandy Mann]

Your formula works for me so I would think that the problem may be the value
in B4 or Product List A1 having spaces or other non-printing characters in
the cell which you cannot see.

Try:

=len(B4) and see if it returns 3 and then try it on A1.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[CIL]

make sure that you do not have " " space on either of the cells..