As the Last. I have an index match formula which goes through a list and returns a date based on an email address. We have the same date in both columns so.
Lets say we use a normal INDEX MATCH formula to look up Davids salary.
Index match if a date is in a range Hello there I have had a look at a rather similar thread link here but despite a lot of tinkering about I cannot get it to function to my requirements. While it may look a bit complex at first glance the formulas logic is really. As the Last. Now in cell C2 apply the formula as A2B2.