Redefine Table Array
I already have set up a Vlookup but i want to add more items to this how to i
make the range include the newly added data |
I like to put my table on a dedicated worksheet. Then I can use the whole
column without worrying. =vlookup(a1,sheet2!a:e,3,false) But you could use a dynamic range name that grows/extracts with your data. Take a look at Debra Dalgleish's site to read more about it: http://www.contextures.com/xlNames01.html#Dynamic Shaya M wrote: I already have set up a Vlookup but i want to add more items to this how to i make the range include the newly added data -- Dave Peterson |
All times are GMT +1. The time now is 12:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com