• 512K Members
• 5,930 Online
• 609K Conversations

Highlighted
New 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

6 Replies

# RE: I need help with excel

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

# RE: I need help with excel

@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

# RE: I need help with excel

As variant

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

# RE: I need help with excel

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)

# RE: I need help with excel

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

# RE: I need help with excel

@crazyshoots  Thank you very much for your help.

I'll try both

Related Conversations