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 vlookup only has one criterion, I concatenated the employee name and number. Now, the vlookup looks for the concatenated formulas in the cells as opposed to the value (name and number). Does anyone know how to fix this? Or possibly suggest another formula for verifying two criteria match and then returning another piece of data based on that criteria. Thanks ahead of time.
4 Replies
If FILTER() is not available another option is INDEX/MATCH
=INDEX(result, MATCH(1, INDEX( (names=name)*(numbers=number),0),0))- This somewhat works, but I want it to only return the result (the date) as opposed to the correct criteria (name and number) along with the date. Is there anyway to just have it return the result?
