| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
INDIRECT Function
Hi!
is it possible to return this kind of string from the indirect function (to use in a LOOKUP function): 'VARIABLE'!B$13:B$46 where VARIABLE is in the cell A1, and gives me the worksheet to lookup the values. Thanks in advance |
|
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
|
INDIRECT Function
One way:
=LOOKUP(A2,INDIRECT("'" & A1 & "'!B13:B36"),$J$13:$J$36) In article , Alberto Pinto wrote: Hi! is it possible to return this kind of string from the indirect function (to use in a LOOKUP function): 'VARIABLE'!B$13:B$46 where VARIABLE is in the cell A1, and gives me the worksheet to lookup the values. Thanks in advance |
|
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
|
INDIRECT Function
JE McGimpsey wrote:
One way: =LOOKUP(A2,INDIRECT("'" & A1 & "'!B13:B36"),$J$13:$J$36) In article , Alberto Pinto wrote: Hi! is it possible to return this kind of string from the indirect function (to use in a LOOKUP function): 'VARIABLE'!B$13:B$46 where VARIABLE is in the cell A1, and gives me the worksheet to lookup the values. Thanks in advance Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
| include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
| Using Indirect Function | Excel Worksheet Functions | |||
| INDIRECT function question | Excel Worksheet Functions | |||
| Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
Hybrid Mode
