in sheet one the columns a
-Publisher
Reference Number
-Product Title
-Last Production Date

and in sheet two, the columns a
-Publisher
-Product Title
-Reference Number
-Platform

sheet two has 8243 rows and sheet one has only 227.

hope that helps.
"Toppers" wrote in message
...
I think Bob meant what fields are what columns on each sheet ...

"Farrah" wrote:

its laid out in columns. So the first worksheet has 227 entries (the one
with the Last production date) and the second worksheet has 8243 rows .
As you see there is more data in one worksheet than the other, but i
really
need to find the products that match with the last date of production.

hope that makes sense.

thanks


"Bob Phillips" wrote in message
...
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