Lookup

Hello All,

I'm looking for a non VBA formula to find the last date an entry was made with conditions.

Return the date when the last entry "A" was made if the amount is > 1.0 and Mr. Hunt was a Lead or Assistant. (not Staff)

Also for "B"

Return the date when the last entry "B" was made if the amount is > 1.0 and Mr. Hunt was a Lead or Assistant. (not Staff)


Thank you All.