vlookup - error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I can't find a solution to the following problem:
I am using VLOOKUP to find a value relating to a product code.
This is my formula.
=VLOOKUP(A16,Sheet3!$A$6:$B$1690,2,FALSE)
The problem is I know that there are matching product codes, but they are
still showing up as #N/A.

However, when I plug the product code in by hand in the array it works! But
then I can't plug in all product codes as it would be the same as going
through the whole table by hand without using any lookup formulas... Maybe it
has something to do with the format of the product code?

Please help!
Thanks
Sara
 
I have had the same thing happen.

I tried your formula just now and it works. Was Sheet 3 renamed? If not, 3
ideas:

First, are you absolutely sure that column A of sheet 3 is the column with
the data which is being compared?

Second, I would suggest highlighting cells A6 to B1690 in sheet three and
then naming that range (quickest way to do it is after you've highlighted the
section you go to that box right above Column A's header and click on it and
type in a range name--no spaces). Then replace the $b$6: etc with the range
name in the vlookup formula.

Third--sometimes the formula is working, and the problem is that the names
are really not all equal. Sometimes formatting does this, sometimes
importing hte data has added blank spaces. Test the data directly with a
simple logic statement like A6=sheet3!a16. if all else fails, first rewrite
the formula in the same sheet as the data that you are looking up--put
everytihing in the same sheet right next to each other and see item by item
where the disconnect is happening.--
 
Back
Top