I found a question (not from me) and response in a 2011 forum:
A B
1 WINE PH
2 Chard 3.24
3 Merlot 3.36
4 Cab 3.44
5 Merlot 3.38
6 Chard 3.26
7 Chard 3.45
8 Cab 3.41
9 Merlot 3.33
=LOOKUP(2,1/($A$1:$A$9="Chard"),$B$1:$B$9) that returns the value in column B for the LAST occurrence of a text string "Chard" in column A of an unsorted table (returns 3.45)
This Lookup() formula works well if looking for an exact match (i.e., "Chard"), but I have a slightly different need: I am looking for the last cell in column A that INCLUDES the text string, not an exact match and not case-sensitive ("e.g. "Swiss Chard", "chard", "Charder", etc) of an unsorted table and want to return the corresponding value from column B (which in my case happens to be a date). Lookup() apparently doesn't like wildcards because using "*Chard*" doesn't work. Help.
Bookmarks