Forum Discussion

dschw2020's avatar
dschw2020
Copper Contributor
Jun 28, 2022

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

 

 

Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jun 28, 2022

    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. 

Resources