Lookup to multiple 2 tables

[Rolly_Sefu]

Hello,

I want to multiply the numbers from 2 table but only if they match

T1 data : {"a123";"a124";"a125";"a126";"a127";"a128"}
T1 values: {11;12;13;14;15;16}
T1 criteria: {"a123";"a125";"a128";0;0;0}

in order to keep T1's number sequence I used the formula ( =IF(ISNUMBER(MATCH(A3:A8;C3:C8;0));B3:B8;0) ) to get the values based T1 criteria
the result: T1: {11;0;13;0;0;16}

T2 data: {0;"a123";0;0;"a125";"a128"}
T2 values: {0;2;0;0;3;4}

How can I multiply T1 * T2 ( {11;0;13;0;0;16} * {0;2;0;0;3;4} ) - NOK

I would need to multiply {11;0;13;0;0;16} * {2;0;3;0;0;4}

Any ideas ?

 

[Rolly_Sefu]

Hy, it's exactly what i needed.

I did not know about the T function, why does it work with vlookup ?

Thanks for the help.