I would like a Formula to display the Date from the corresponding row where the following conditions are met;
Search for Cell within Column B (Animal) for text string "cat" (multiple strings exist within each cell) + Column A (Type) is "car" = display most recent date
Desired result is Highlighted
I have tried Formulas such as ISNUMBER, MID without success.
Any help most appreciated.
Last edited by ajlogan; 12-15-2018 at 12:22 AM.
Try below formula
=LOOKUP(2,1/SEARCH(TRIM(SUBSTITUTE($A$7,""""," * ")),$A$2:$A$5&" + "&$B$2:$B$5&" "),$C$2:$C$5)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Shorter version of Samba's formula
=LOOKUP(1,-SEARCH(SUBSTITUTE(A7,"""","*"),A2:A5&" + "&B2:B5),C2:C5)
Thank you for your suggestions. They both work well but a small change required.
The required criteria (A7 - Type and Animal) each need to be hard coded into the formula without reference to a specific cell for the criteria (A7).
for example Search for "car" & "cat" both embedded within the formula.
Kind regards
Try this
=LOOKUP(1,-SEARCH("car*cat",A2:A5&B2:B5),C2:C5)
Worked perfectly - Thanks great work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks