| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - TABLE_ARRAY SUBJECT TO CHANGE
Hi,
How can I re-word the vlookup in A3 below so that when cell A1 value changes then the TABLE_ARRAY in A3 will adjust to the new value, i.e., Equity2, Fixed1, Alternative4, etc.. A B C 1 Equity1 [this is a formula referring to the tab name and subject to change] 2 11/30/2008 3 =VLOOKUP(A2,Equity1!B10:Q561,3,FALSE) Thank you. -- Orlando Vazquez |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Table_Array arg for VLOOKUP | Excel Worksheet Functions | |||
| vlookup table_array | Excel Discussion (Misc queries) | |||
| How to change a Table_Array size in a VLookup formula? | Excel Discussion (Misc queries) | |||
| VLOOKUP TABLE_ARRAY | Excel Worksheet Functions | |||
| mass change table_array Name in VLOOKUP formula | Excel Worksheet Functions | |||
![ORLANDO VAZQUEZ[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
