Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
Finding min,max in an array using selected rows from a table | Excel Worksheet Functions | |||
Table Array in VLOOKUP Relies on Data Validation | Excel Worksheet Functions | |||
How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
table | Excel Discussion (Misc queries) |