Forum Discussion
VLOOKUP or another formula needed
Hi everyone. I need help with a formula, possibly a VLOOKUP? In the below example, I need to search and find matches from Column A and Column M. If matches are found, I need to know if Column B...
=ISNA(VLOOKUP($A3&$B3,$M$3:$M$24&$N$3:$N$24,1,FALSE))You can try this formula / rule for conditional formatting. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.