• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Equation with multiple vertical and horizontal conditions

Hany ali

Active Member
Dear Sirs and Professors ,I want you Help in fount Equation to get the Result By Multiple Conditions
I want This Price From Data Sheet
by Four Conditions ,
1- Excursion Name
2- Supplier Name
3- Vechicle Type
4-By Transfer Region
and if Supplier Name =Supplier,we
will get Price From Supplier Column In Data Sheet and after that to
Multiply in pax Number in B Column
in Total Sheet without care by
Vehicle Type
but if i Choose Spring Tours ,
we will get the Result By this Four Conditions
 

Attachments

  • Supplier1.xlsm
    25.4 KB · Views: 11
  • 1.png
    1.png
    58.1 KB · Views: 5
Hi @Hany ali ,

See if is ok ?

=INDEX(Data!$V$7:$AT$11,MATCH(Total!D2,Data!$U$7:$U$11,0),MATCH(H2,Data!$V$4:$AT$4,0)+MATCH(Total!G2,Data!$V$6:$Z$6,0)-1)
 

Attachments

  • Supplier1.xlsm
    27.5 KB · Views: 9
hello Masters ,Please I want Your Helping to found another Formula for this way to get the same Result by Multiply Condition the same in the File
33545
 

Attachments

  • 1.png
    1.png
    39.7 KB · Views: 3
  • Transfer2.xlsm
    56.5 KB · Views: 7
Try........

In G3, copied right to H3 and all copied down :

=IFERROR(OFFSET(Data!$A$1,MATCH(1,INDEX((Data!$A$2:$A$11=$B3)*(Data!$AL$4:$AL$11=$C3),0),0),MATCH($E3,Data!$B$2:$I$2,0)+MATCH($F3,Data!$B$1:$AK$1,0)+COLUMN(A1)-2),"")

66286

Regards
Bosco
 
Back
Top