Forum Discussion
OnurhanToy
Dec 09, 2019Copper Contributor
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
Wyn Hopkins
Dec 09, 2019MVP
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
- OnurhanToyDec 09, 2019Copper Contributor
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
- SergeiBaklanDec 09, 2019Diamond Contributor
As variant
=IFNA(LOOKUP(2,1/($A:$A=$I5)/($B:$B=$J5)/($C:$C=$K5)/($D:$D=$L5),$E:$E),"no such")- OnurhanToyDec 09, 2019Copper Contributor
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)