I need help with excel

Copper Contributor

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

picture.png

@OnurhanToy 

As variant

=IFNA(LOOKUP(2,1/($A:$A=$I5)/($B:$B=$J5)/($C:$C=$K5)/($D:$D=$L5),$E:$E),"no such")

@Sergei Baklan 

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, @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.

@crazyshoots  Thank you very much for your help.

 

I'll try both :)