Hello

Can anyone help please?

I need to look up an estimate number which is workbook number 1 and find it
in work book number 2 and then find the selling price value and enter it in a
blank cell in work book number 1.

I thought this would work with a vlookup but I only get some correct results
and then the ones it can not locate it puts in the last value that is found
in workbook 2.

How do I get the spreadsheet to give me only the correct answers and where
the estimate number can not be found leave it blank or but n/a?

The estimate numbers are combinations of letters and numbers e.g. I45236.
Could this be causing the problem?
--
Thanks for your advice in advance.
Excel Crazy