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