Aug 29 2021 07:08 PM
Hello, Above formula works. However if there is no match in table 2 ("a" is not in table 2, Cell O3 returns as #N/A. Need to use ISNA function within the the formula above but have been unsuccessful. How do I not show #N/A? Appreciate the help. Thanks.
Aug 29 2021 07:44 PM
SolutionAug 29 2021 07:59 PM
Aug 29 2021 07:44 PM
Solution