VLOOKUP (XP)

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),"")

Re: VLOOKUP (XP)

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?