VLOOKUP

[gatarossi]

Dear all,

I'm trying to do a dynamic vlookup formula... as I have more than 60
sheets, I would like to change the sheet's name in the vlookup
formula:

=VLOOKUP(A7,'aa'!2:1000,VLOOKUP(D3,aux!A:B,2,0),0)

In each sheet I have, I have the period in the columns... so this is
the purpose that I have the second VLOOKUP, to find the correct period
column,
but I need to change the sheet's name too, and I have a cell that
contains the name´s sheet to search the data, for example "A1".

How can I change this formula?

For example, If I have the value "bb" in cell "A1", the formula will
change to:

=VLOOKUP(A7,'bb'!2:1000,VLOOKUP(D3,aux!A:B,2,0),0)

Thanks in advance!!!

André.

 

[Niek Otten]

Hi André,

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Dear all,

I'm trying to do a dynamic vlookup formula... as I have more than 60
sheets, I would like to change the sheet's name in the vlookup
formula:

=VLOOKUP(A7,'aa'!2:1000,VLOOKUP(D3,aux!A:B,2,0),0)

In each sheet I have, I have the period in the columns... so this is
the purpose that I have the second VLOOKUP, to find the correct period
column,
but I need to change the sheet's name too, and I have a cell that
contains the name´s sheet to search the data, for example "A1".

How can I change this formula?

For example, If I have the value "bb" in cell "A1", the formula will
change to:

=VLOOKUP(A7,'bb'!2:1000,VLOOKUP(D3,aux!A:B,2,0),0)

Thanks in advance!!!

André.