ExcelBanter - INDIRECT Function

ExcelBanter (https://www.excelbanter.com/)

- Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)

- - INDIRECT Function (https://www.excelbanter.com/links-linking-excel/85137-indirect-function.html)

Alberto Pinto

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

JE McGimpsey

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

Alberto Pinto

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

All times are GMT +1. The time now is 05:44 PM.