Jun 28 2022 10:20 AM
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 and Column N match as well. If they do not, I need to highlight it or return something to show that the prices do not match.
Thanks!!
Jun 28 2022 11:50 AM
=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.