How to use Index and match funtion in VBA-CodePudding

I would like to use the following function in VBA.

=INDEX(Zones!$G$3:$S$273;MATCH($A2;Zones!$C$3:$C$272;);MATCH($B2;Zones!$G$2:$S$2;))

I use two tables. In the table "Data" in column C2:C I would like to transfer the searched results. Can anyone help with VBA coding? Thanks!

CodePudding user response：

Cannot make out from your formula what you are attempting but sounds from your description like you are tying to create a Pivot Table which today you can readily create with Spill Ranges. That is, no call for VBA me thinks.

CodePudding user response：

Thank you for your support and input. Hier are some pictures from my sheets which I use for the data imput.