VLOOKUP or another formula needed

Copper Contributor

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!!

 

 Screen Shot 2022-06-28 at 12.07.51 PM.png

1 Reply

@dschw2020 

=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.