How is the data laid out? Is it one for one on each sheet.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Farrah" wrote in message
...
Hi,

I have two spreadsheets with product info, and in both sheets there is a
reference number that can match them. However, i need to match both the
reference numbers to obtain a date.So for example, i need to find a
product
that was last produced using info from both sheets, one contains the date,
ref, title etc, and the other contains title and ref no. How can i return
the last production date by matching the ref no in both?

hope that makes sense.

Please help me!

Thanks