Lookup latest date and other criteria to return value

M

Malaugrym

New Member
Joined
Feb 19, 2013
Messages
1
Greetings excel guru's,

I have a maintenance spreadsheet that has the following information

(A)Tag #, (B)Date...(G) Condition

What I'm trying to do is on a master spreadsheet, lookup the latest entry for the matching tag # and input the condition. I have tried using INDEX/MATCH, and am able to get a MAX/IF to return the right date for a specific tag, but for some reason I'm stumped on how to get the condition for the latest date.

Any guidance would be immensely 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.
You must log in or register to reply here.

Similar threads

C
  • Question Question
Return closest date based on three criteria being true, or return "no date found"
Replies
8
Views
292
chris_bosten
C
S
  • Question Question
Multiple Criteria Lookup Return Value
Replies
1
Views
234
Vogateer
V
A
  • Question Question
Excel - looking up data with multiple criteria from table/array, date must be same or nearest before the target cell
Replies
8
Views
510
Peter_SSs
Peter_SSs
B
  • Solved
Return Last Value in Range Using INDEX MATCH
Replies
3
Views
279
Alex Blakenburg
A
A
  • Question Question
Index and Match for 2No criteria only partially returning values other values #ref error.
Replies
6
Views
485
roelandwatteeuw
R

Forum statistics

Threads
1,223,247
Messages
6,171,007
Members
452,374
Latest member
keccles

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top