am new to VBA excel.
i am trying to use the macro for index match but some am not able to get the that .
am using the below formaula .
Note: Sheet1!$O$1 is constant criteria
Please help me with this