Vlookup with condition

[Zaid]

Hello Everyone,

See attached the excel for your reference.

I have table A1:E10 , where i enter Internal team transfers "From Team" to " To Team" with Month

Now what i want in Table G1:S15 is that whenever a transfer takes place, for that particular month, tables gets filled up as +1 for "To Team" and -1 for "From Team." Also if there are multiple transfers happening for a particular team in a month then that numbers should sum up.

For your easy understanding, i have filled the table as per my logic explained above.

Let me know if you need any more info.

Regards
Mohammad

[Fotis1991]

Can you pls explain which is the difference from this thread?

http://www.excelforum.com/excel-form...n-vlookup.html

[XOR LX]

Hi,

Perhaps, in H2 and copy across and down:

=IFERROR(1/(1/(SUMPRODUCT(($E$2:$E$10=H$1)*((-($B$2:$B$10=$G2))+($C$2:$C$10=$G2))))),"")

Regards

[Zaid]

This is totally different. You can open and see the excel.

[Fotis1991]

This is totally different. You can open and see the excel.

Totaly different? I don't think so..Let's unblock your thread to see the replies..

[Zaid]

I have unblocked it. Please have a look.

[Zaid]

XOR LX

Perfect. This is awesome man. Thanks a lot

[XOR LX]

@Fotis

Thanks for your patience and understanding

@Zaid

You're welcome!