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.
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.
