I am using an index formula with SMALL function to pull all the relevant rows from one worksheet to another. You can see in the attached spreadsheet that the key is the vendor number listed in cell A10 of the REPORT worksheet. I just cannot figure out why my formulas work fine for some vendor numbers, and they are pulling in extra data for others. I would be most grateful if anyone could provide some insight.
Bookmarks