CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
bartek5412
bartek5412

Reputation: 1

Google sheets data comparison

I need to make a formula that will compare if the order is canceled (A:B), then it will be displayed along with the material in the final sheet (C:D) - I don't know how to go about it, does anyone have any idea?

https://i.sstatic.net/jG4dT.png

Upvotes: 0

Views: 28

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

Try this formula

=ArrayFormula(IFERROR(VLOOKUP(E2:E,{B2:B,A2:A},2,0)))

enter image description here

(please adjust formula according to your ranges and locale)

Functions used:

Upvotes: 1

Related Questions