VBA Index/Match multiple criteria

[Sparkplug90]

This is what i ahve have..it works great with only one criteria

Please Login or Register  to view this content.

Now that i ahve collected data from teh same areas the lookup range ("F" & i) has the same data present but the next column ("G" & i) has the coresponding data that i went out

waht i need is for this to Use both Column F and G to find the values

here is the worksheet

Collection Sheet1.xlsm

[Sparkplug90]

anyone able to help?