Dec 08 2019 10:09 PM
Hello everyone,
How to indicate price with variable situations?
I need IF and AND formulas but I couldnt do.Is there anybody WHO can help to me
Dec 08 2019 10:44 PM
Dec 08 2019 11:08 PM
@Wyn Hopkins Hello,As you see on the picture,I want to see price placed on the right section when I choose model,engine,year and colour according to their price on the left section .Thank you
Dec 08 2019 11:19 PM
As variant
=IFNA(LOOKUP(2,1/($A:$A=$I5)/($B:$B=$J5)/($C:$C=$K5)/($D:$D=$L5),$E:$E),"no such")
Dec 08 2019 11:54 PM
Thank you so much for comment.
Is it not possible using this formula ?
=IF(AND(I5=''CLİO'';J5=''1.9'';K5=''2018;L5=''SARI'');166800)
Dec 09 2019 12:01 AM
@OnurhanToy Hi, allow me to chip in.. the way I see it, @Sergei Baklan method is better in the sense that he's looking up the entire range so you can use that one formula.
The one you indicated, If(and; it is very specific and may require changes in order to work perfectly should you have new data going forward.
Dec 09 2019 12:26 AM