The formula for Get Data has two conditions

[Hany ali]

hell every one ,Please I want Your Help to get Data by 2 Conditions from Data Sheet To Entry Sheet ... when I Choose From Transfer Column & Car Kind Column
I want the Result in Total Column
thanks Very Much

 

[bosco_yip]

Maybe,

[B2] =IF(A2="","",VLOOKUP(A2,Data!$B$6:$F$42,MATCH(B2,Data!$B$5:$F$5,0),0)*C2)

and, copied down

Regards

 

[shaikhrulez]

Try this,

=INDEX(Data!$C$6:$F$42,MATCH(A2,Data!$B$6:$B$42,0),MATCH(B2,Data!$C$5:$F$5,0))*C2

 

[Hany ali]

bosco_yip
Thank you very much and this is really required. You are really creative

shaikhrulez
Really, I am very happy to have a variety of wonderful answers to my question
God bless you all