Hello all.

I have a little issue, that I would normally use VBA, but this time I would like to go formula driven.

Data Locations:

I wish to lookup the date in L:8, in an entire sheet, using the 3 variables of "Finish", "POP", and "ABC"

So, the 3 Lookup values are ABC, POP, and Finish, to pull the date in L:8

I wanted to use maybe Vlookup, or IndexMatch, but I dont know how to use it with three different LookUp values. Or maybe a combination with the Find formula?

All the data I need, is in columns H:L.

Thanks for the help

I have a little issue, that I would normally use VBA, but this time I would like to go formula driven.

Data Locations:

- Date is in L:8
- First Variable is in: L:7 = Finish
- Second Variable is in: J:8 = POP
- Third Variable is in: H:8 = ABC

I wish to lookup the date in L:8, in an entire sheet, using the 3 variables of "Finish", "POP", and "ABC"

So, the 3 Lookup values are ABC, POP, and Finish, to pull the date in L:8

I wanted to use maybe Vlookup, or IndexMatch, but I dont know how to use it with three different LookUp values. Or maybe a combination with the Find formula?

All the data I need, is in columns H:L.

Thanks for the help

Last edited: