CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Blake Rindlisbacher
Blake Rindlisbacher

Reputation: 47

How can I make a formula that compares two columns to another two columns?

I need a formula that checks the "Shipping List" and compares it to the "Stored Prices" to make sure that the price isn't too high. If the price is high it will flag column C and mark it as red. I know how to do the conditional formatting to make it red but I can't figure out the formula to make this work. Everything I see online only shows a single column compared to another single column.

Please see example spreadsheet here: https://docs.google.com/spreadsheets/d/1NvTzjCeYlkvR1o-UavCjW2Zm-GwYxiM_wHdU4qrQWEg/edit?usp=sharing

Upvotes: 1

Views: 38

Answers (1)

player0
player0

Reputation: 1

delete column C and use this in C3:

=ARRAYFORMULA(IF(B3:B="",,
 IF(B3:B>IFNA(VLOOKUP(A3:A, E3:F, 2, 0)), 
 "Price To High", "Good")))

enter image description here

Upvotes: 1

Related Questions