LOOKUP function

[corinereyes]

Hello,

Good Day...

If someone could help me with my problem.

I have this data on my worksheet, example; (please note: date format = dd/mm/yyyy)

Sheet 1
ID Number.......Date
10897.............01/01/2011
10896.............01/02/2011
10895.............01/02/2011
10896.............01/02/2011
10897.............01/04/2011

And in another sheet, i have to enter in a cell an ID number, adjacent to that cell should show the latest date that corresponds to that particular ID number in sheet 1, like for example;

Sheet 2
ID Number.......Date
10897............01/04/2011

Im using a vlookup formula, but the data i have from sheet 1 contains an ID numbers that may appear multiple times. vlookup searches for the first match it sees and does not display the latest date from that particulat ID number.

I hope you can help me.

Thanks.
Corine

[zbor]

Here.. Solutions for latest and greatest date..

(If your table is sorted then you can use just first solution)

[Fotis1991]

Hi

If range of your Data is Sheet1 A2:B6, then in Sheet2, let's say in E2, put the ID number 10897.

Then you can use this formula:

=IF(Sheet1!A2:A6=Sheet2!E2;MAX(Sheet1!B2:B6);"")

The result is 01/04/2011

Hope to helps you.

[corinereyes]

Hello,

Thank you guys, both formula is working perfect!

Thanks again.
Corine