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
6 Replies
- 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")
