Hello Friends,
How can this formula be written in a VBA code to return results only - not formula
=INDEX(suppliers,MATCH(B11,ref,0))
suppliers & ref are named ranges within the worksheet
I want the it to be applied to C11:C77
Any help would be appreciated.
Regards,
Humayun
How can this formula be written in a VBA code to return results only - not formula
=INDEX(suppliers,MATCH(B11,ref,0))
suppliers & ref are named ranges within the worksheet
I want the it to be applied to C11:C77
Any help would be appreciated.
Regards,
Humayun