G Guest Jun 9, 2005 #1 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 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
D Dave Peterson Jun 10, 2005 #2 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
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
