Write formula with code ...
Copy this formula
=INDEX(SOURCE;MATCH($A$20;INDEX(SOURCE;;1);0);MATC H(C$19;INDEX(SOURCE;1;0);0))
Then go to Excel, press record macro, paste that formula into cell C21, and press Enter. Then stop
the macro recorder, and post the code that was generated.
HTH,
Bernie
MS Excel MVP
"Sige" wrote in message
ps.com...
The second ...
|