Greetings!
If someone could please help with this...I need a formula that looks up a value of a cell (C4) in column 2 of my second table and then returned the latest date (from column 1) of that incident to the cell (G4).
I have attached my worksheet - please let me know if you are not understanding what I am trying to do.
Thank you.
Last edited by happyhorse; 01-14-2013 at 12:59 PM.
In cell G4:
=MAX(INDEX($B$12:$B$30*($C$12:$C$30=C4),0))
Thanks so much, Andrew-R - it worked perfectly!
Sorry, I need to re-open this thread. When I use this formula, if there is nothing for the event in the list of my 2nd table, it defaults to showing 0-Jan-00. How do I make it stay blank?
Like this...
=IF(C4="","",MAX(INDEX($B$12:$B$30*($C$12:$C$30=C4),0)))
Again in G4 and copied down.
Try this one, which is an extension of Andrew's formula..
=IF(MAX(INDEX($B$12:$B$30*($C$12:$C$30=C4),0))=0,"",MAX(INDEX($B$12:$B$30*($C$12:$C$30=C4),0)) )
One test is worth a thousand opinions.
Actually the best combination of the two is probably:
=IF(COUNTIF($C$12:$C$30,C4)=0,"",MAX(INDEX($B$12:$B$30*($C$12:$C$30=C4),0)))
Andrew - I am getting the same results with this.
Marvin - This worked!
Thanks to both of you for your quick responses!!! Love this forum!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks