using MAX(INDEX((D1=B1:B8)*A1:A8,)) to search for most current date but how to use "wildcards"?

[sadams1]

greatly appreciate anyone taking any time to check out this seemingly straightforward solution that eludes me...the screenshot shows a simple table & search. Works great when the exact match is found but would it to be more flexible which is shown in the callout in the screenshot. Is this possible as is or am I biting off more than I can chew? Many thanks! Steve

 

[Scott Huish]

You didn't say what version you have, but this seems to work in Excel 365:

=LOOKUP(9^9,FIND(D1,B1:B8),A1:A8)

 

[sadams1]

hello Scott & many thanks for the reply! I plugged the code in & the result was "45272". I did a straight copy & paste so shouldn't have fat fingered anything. Attached is what I'm seeing.

 

[sadams1]

sorry for not answering what version...yes, using "365"

 

[Scott Huish]

You need to format that cell as a date like the others

 

[sadams1]

huge apology! Just love when I completely miss something right in front of my face. Works great & greatly appreciate this!