Forum Discussion

OnurhanToy's avatar
OnurhanToy
Copper Contributor
Dec 09, 2019

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    
excel
Formulas and Functions
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Dec 09, 2019
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
  • OnurhanToy's avatar
    OnurhanToy
    Copper Contributor
    Dec 09, 2019

    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

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Dec 09, 2019

      OnurhanToy 

      As variant

      =IFNA(LOOKUP(2,1/($A:$A=$I5)/($B:$B=$J5)/($C:$C=$K5)/($D:$D=$L5),$E:$E),"no such")
      • OnurhanToy's avatar
        OnurhanToy
        Copper Contributor
        Dec 09, 2019

        SergeiBaklan 

        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) 

Resources