VLOOKUP or another formula needed

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




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

1 Reply



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.