Forum Discussion
Linking data across worksheets
I'm sure this question has been addressed many times in different forms. So if someone has a link to direct me to, please help. I have not found anything to explain what I would like to accomplish di...
J_How Sounds to me you can achieve your goal by using a structured Excel table for your master list and refer to that table in your VLOOKUP or INDEX/MATCH functions, whichever you are using.
Structured tables expand automatically when you type a new part number below the last row, so that you don't have to update your lookup ranges elsewhere. More about how to use then can be found here
Riny_van_Eekelen I'll give this a look over. Thank you for the quick response!