Forum Discussion
Excel Help
hi all, I'm trying to build a sheet with a master list of items all with data that is unique to the first cell name. i am then adding sheets on which can made up of some but not all of items on the ...
Perhaps, you should learn how to use Index & Match which is way more powerful, dynamic and doesn't break unlike VLOOKUP while adding more columns in the data-set.
A quick video will help you understand:
https://youtu.be/3S4DuYjeWKQ
A quick video will help you understand:
https://youtu.be/3S4DuYjeWKQ