Wild character sumproduct...

HI Experts...

I am looking for a comparison, where in I have values as follows..

A1 IN
A2 PRD
B1 01
B2 02
B3 03
.
.
.
.
B10 10

There is set of data in D which gives result PRD:R-IN01, there are around 1000 records of this nature.
I already have a sumproduct equation for some other calculations. There is one condition where I will be combining A2, A1 and B1, have it compared with
PRD:R-IN01, in the whole process the comparison should ignore ":R" succeeded by PRD and only compare with combined string A2 (PRD) A1 (IN) B1 (01)....
":R" is one of the parameters which will be different for different scenarios.

please help..

Hi Robert,

Thanks for responding..attached please find sample workbook for your reference.

Hope I am able to convey the problem statement correctly..

Try ths in D2

Please Login or Register  to view this content.