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.

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


Replace @mailinator.com with @tiscali.co.uk


"Johosh" wrote in message
...
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.

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


"Johosh" wrote in message
...
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.