I am in need of a formula to put in sales.xls to take cell A2 from sheet1, look for it in sales2.xls, sheet1, and then return that value in sales.xls sheet2. Exactly what I am doing is taking a customer name that an engineer types in a quote sheet and looking it up in another workbook and entering that customer's name and address onto a packing slip. I wanted to be able to do this without having the both sheets in the same file (for fear the guys would delete something). Is this at all possible? I can clarify if needed. Thank you in advance for any suggestions.