VLOOKUP confusion

[Dave Rattigan]

User will enter a product name in column A and in column B I need it to return the associated product code. I then made 2 columns on the same worksheet with product names in column G and the associated product codes in column H.
I was given an idea to use VLOOKUP and tried it but it didn't work....what's wrong?
-----------
In column B, my formula looks like this:
=IF(A1=" ","Error!",VLOOKUP(A1,G1:H25,1,FALSE))
------------------
I tested it and all it does is return the product name listed in column G not the associated product code in column H which is what I need it to return.

Thanks http://sysopt.earthweb.com/forum/smile.gif
Dave Rattigan alias ratman

[Dave Rattigan]

I answered my own question....hehehehethe "1" signifies your 1st column in the search.
Change it to 2 and vwola!!!! it works !!!
=IF(A1=" ","Error!",VLOOKUP(A1,F1:G21,2,FALSE))