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 out![]()
Please 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