Forum Discussion
I need help with excel
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
Hi, could you provide some more information including an example and ideally a sample file explaining in as simple terms as possible what you are trying to do.
Thanks
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
As variant
=IFNA(LOOKUP(2,1/($A:$A=$I5)/($B:$B=$J5)/($C:$C=$K5)/($D:$D=$L5),$E:$E),"no such")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)
OnurhanToy Hi, allow me to chip in.. the way I see it, SergeiBaklan 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.
