help with if 3 conditions are met, yes, if not, no.

[jermz]

hi excel gurus, need help in creating a formula for the blue cells(as seen in the img)

example in cell F2

look for row A=BMW, row B=blue

if row C is new, "Y", else "N")

the formula now needs to refer to A2 where all conditions are met.

TIA!

EXCEL.png

[AliGW]

Try this:

=IF(LOOKUP(2,1/(($A$2:$A$22=$E2)*($B$2:$B$22=F$1)),$C$2:$C$22)="New","Y","N")

By the way, it's important to know that rows are horizontal: the vertical are columns.

[zbor]

Try

Please Login or Register  to view this content.

[davsth]

Whilst both formula work answering your request, is it impossible to have both new and used of the same colour car?

[jermz]

Thank you AliGW and zbor! you guys rule!

[Ace_XL]

Another way..

=LOOKUP(INDEX($C$2:$C$1000,MATCH(1,INDEX(($A$2:$A$1000=$E2)*($B$2:$B$1000=F$1),0),0)),{"New","Used"},{"Y","N"})

[AliGW]

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.