This is what i ahve have..it works great with only one criteria
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 outPlease Login or Register to view this content.
waht i need is for this to Use both Column F and G to find the values
here is the worksheet
Collection Sheet1.xlsm
Bookmarks