| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i want to do a vlookup but i want the table array to be changing
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy an array without changing relative cell references? | Excel Worksheet Functions | |||
| Problem with Vlookup array selection | Excel Worksheet Functions | |||
| Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
| vlookup with validation table | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
