I am working on an excel workbook that has numerous worksheets. I have an inventory list that I am separating by different vendors. Anyway, I have to link up a buch of rows on the main list using a VLOOKUP formula. however there are more that 10,000 items. so here is what I want. the current formula looks like this:
I want to know if there is a way that I can substitute the letters in green with a reference that will link to the appropriate page so that I dont have to go an link the items page by page. I have a colum already with the vendor names which matches the worksheet titles. Is there a way or function to keep the VLOOKUP that i need but substitute the green part with the title that I can get from a reference of the "vendor name colunm"
Please help me out guys. thank you!