sumproduct

[vbastarter]

Hi I'm trying to build sumproduct that can lookup an entire column values
occuring any where in other 3 columns. This is huge data so I like to use
sumproduct to fasten the process.
Ex C
12Rina

 

[vbastarter]

Hi I'm trying to build sumproduct that can lookup an entire column values
occuring any where in other 3 columns. This is huge data so I like to use
sumproduct to fasten the process.
Ex C D
Rina 123 gHI
Sap 12 cAS
Cas 123 Rina Cl

Now I need to pick entire rowD3(123 Rina Cl). Simultaneously Loop up C
values in E, F. Now I know how to do this in general but dont know how to
achieve in sumproduct.

TIA