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

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

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

On 16 Aug, 12:58, "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- Hide quoted text -

- Show quoted text -

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

so what will the formula be for this,please?

wrote in message
oups.com...
On 16 Aug, 12:58, "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- Hide quoted text -

- Show quoted text -

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

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

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

Look at VLOOKUP in HELP.


"Farrah" wrote:

so what will the formula be for this,please?

wrote in message
oups.com...
On 16 Aug, 12:58, "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- Hide quoted text -

- Show quoted text -

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

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