=VLOOKUP($A$3,OFFSET(INDIRECT(ADDRESS(1,17,1,1,TEX T(COLUMN(D3)-3,"00"))),0,0,100,2),2,FALSE)
^
This work for 100 rows, adjust it to expected max number of rows (or max row
No, 65536 in Excel2003)!


Regards,
Stefi


€žLynn€� ezt Ã*rta:

Have this function

Look up value : A3
Table Array: '01'!Q:S
Column Index Number:2
Range Look Up: False

Want to copy formula into other column
Not change Lookupvalue:A3
Change Table Array:02 and keeping adding for example column D=01. E=02,F=03
not change in table array Q:S
How can I do this?



--
Thanks
Lynn