VLOOKUP (XP)

[milkyway]

Hello,
I am trying to use the VLOOKUP to create the following: Value to look for is in A1, look for it in Column 1 of table in Sheet2, return value in column 2 in B1...how can I write this? What I have so far (which obviously is not working: =IF(A1<>"",VLOOKUP(1,Inventory!A1:C74,2),"")

Please help!

[pieterse]

Apart from a typo in your message I see nothing wrong:

=IF(A1<>"",VLOOKUP(1,Inventory!A1:C74,2),"")
must be
=IF(A1<>"",VLOOKUP(A1,Inventory!A1:C74,2),"")

Note that without the last argument, vlookup gives an entry close to the one you are trying to match when no match is found.

To return an exact match, you need this:

=IF(A1<>"",VLOOKUP(A1,Inventory!A1:C74,2,FALSE),"" )
What do you get and what would you expect?

[milkyway]

Hello Jan Karel,
Thank you, it works now, I actually ended up understanding my mistake. However I would have another question for you: How do I save a file while keeping the number format of the cell (i.e: when I try to run a macro to save as file name = Cell M3, instead of getting 00002, I get 2)...How can I make it keep the zeros in front?

[sdckapr]

In the macro use something like

filename = format(range("m3"),"00000")& ".xls"

Steve

[milkyway]

Thank you very much Steve.