View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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 ...