So essentially I have a worksheet with multiple tabs used for allocating items to different locations. I want to create a summary sheet that returns data if that cell is under several different headings. I would like the summary sheet to look through the rest of the document for the description, then the style, then the size, then return a value next to it. So for example, cell C2 in Example 1 should find the descrption "Basic Cotton Tee," then "Style 1," then size "S," then finally bring back the correct value, in this case it would be 3. Hopefully I'm explaining this well. I'm not sure how to coordinate the VLOOKUPs and HLOOKUPs or INDEX functions correctly here. Thank you!
Example 1.xlsx Example 2.xlsx
Bookmarks