| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Reference
Hi, Is it possible to make Array References dynamic? For example I have a formula which is something like this: =VLOOKUP(A1, [excelFile.xls]*sheetTab*!A1:C10, 2, FALSE) Is it possible for the value of *sheetTab* in above to depend on the value of a cell? So instead of above, I would have something like this: =VLOOKUP(A1, [excelFile.xls]*A2*!A1:C10, 2, FALSE) Obviously this formula doesn't work, but hopefully I got my point accross. Thanks in advance -- anar_baku ------------------------------------------------------------------------ anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259 View this thread: http://www.excelforum.com/showthread...hreadid=489099 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting all positions of a value in an array or reference | Excel Discussion (Misc queries) | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| Array formula reference | Excel Discussion (Misc queries) | |||
| Array formula reference (Corrected) | Excel Discussion (Misc queries) | |||
| How do I return an entire row of data from a reference array? | Excel Worksheet Functions | |||
Threaded Mode
