i want to do a vlookup but i want the table array to be changing
 

i want to do a vlookup but i want the table array to be changing
 

You can use a dynamic range if you mean that the table size can
expand/condense

Example here


http://www.contextures.com/xlNames01.html#Dynamic


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"dimitris" wrote in message
...

i want to do a vlookup but i want the table array to be changi
 

i dont want the table size to change in size. I want to use a diffrent table
according to a function. for example for date 1/1/2001 i want to use table1
and for 2/1/2001 to use table2 ......

"Peo Sjoblom" wrote:

You can use a dynamic range if you mean that the table size can
expand/condense

Example here


http://www.contextures.com/xlNames01.html#Dynamic


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"dimitris" wrote in message
...

i want to do a vlookup but i want the table array to be changi
 

Where would the date be indicated?

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"dimitris" wrote in message
...
i dont want the table size to change in size. I want to use a diffrent
table
according to a function. for example for date 1/1/2001 i want to use
table1
and for 2/1/2001 to use table2 ......

"Peo Sjoblom" wrote:

You can use a dynamic range if you mean that the table size can
expand/condense

Example here


http://www.contextures.com/xlNames01.html#Dynamic


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"dimitris" wrote in message
...