Jul 23 2021 07:36 AM - edited Jul 23 2021 07:49 AM
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.
Jul 23 2021 07:51 AM
SolutionJul 23 2021 07:56 AM
If FILTER() is not available another option is INDEX/MATCH
=INDEX(result, MATCH(1, INDEX( (names=name)*(numbers=number),0),0))
Jul 26 2021 06:50 AM
Jul 26 2021 07:13 AM
Jul 23 2021 07:51 AM
Solution