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

[Peo Sjoblom]

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]

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]

Where would the date be indicated?

--


Regards,

Peo Sjoblom

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