.. vlookup(I8,customers,2,false).
Customers is the name of the second sheet.

Admittedly, I fell for your 2nd line above in your earlier response, and
thought you might have crafted the table array wrongly. Afterall, you
re-typed the formula in your response (with possible typos, omissions, etc)
instead of just copying n pasting direct from the formula bar

If you had put the 2nd line as:
Customers is the name *on* the second sheet.
then I would have read "Customers" as a defined range
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---