Please HElp!!

[Farrah]

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

 

[Bob Phillips]

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]

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

 

[aidan.heritage]

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






- Show quoted text -

VLOOKUP will do it for you (assuming you have unique values in the
target list)

 

[Farrah]

so what will the formula be for this,please?

VLOOKUP will do it for you (assuming you have unique values in the
target list)

 

[Toppers]

I think Bob meant what fields are what columns on each sheet ...

 

[Toppers]

..... that's why we need to know what data is what columns so we can provide a
formula!

Look at VLOOKUP in HELP.

 

[Farrah]

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

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

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

hope that helps.