Forum Discussion
Solved
Vlookup searching for formula rather than the value the formula returns
In order to automate a work process, I am using the vlookup function. However, I have multiple criteria (an employee name and a number) that need to match in order for it to return a date. Since vloo...
If FILTER() is not available another option is INDEX/MATCH
=INDEX(result, MATCH(1, INDEX( (names=name)*(numbers=number),0),0))