# Latest date - Match/lookup

#### gomukuma

##### New Member
Hi,
I have a colleague who is struggling with a look up, if anyone has any ideas on how to evaluate...

Data
Job No Date
51 01.09.14
40 02.08.14
35 25.06.14

Summary:
Job No Latest Date
40 formula to return the latest date (ie 01.09.14)

Any assistance would be grately appreciated.

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Is the latest date for 40 not 02/08/2014?

If so try:

=MAX(--(\$A\$1:\$A\$3=40)*\$B\$1:\$B\$3)

Enter this via CNTL-SHIFT_ENTER as it's array formula.

Is the latest date for 40 not 02/08/2014?

If so try:

=MAX(--(\$A\$1:\$A\$3=40)*\$B\$1:\$B\$3)

Enter this via CNTL-SHIFT_ENTER as it's array formula.

Sorry, Just realised i should have had more dates for each job number..

Job No Date
40 01.09
40 02.08
40 25.06

Your formula is perfect - Thanks

Last edited:
1st Sept is more recent that 2nd August

But that date is not associated with Job No = 40...

Replies
0
Views
446
Replies
1
Views
594
Replies
7
Views
315
Replies
13
Views
457
Replies
2
Views
749

1,196,052
Messages
6,013,112
Members
441,748
Latest member
MrBigglesworth

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back