vlookup in several sheets
 

Hi
I want to make the range in my vlookup formula variable. If for example I
use the account from 2200 into 2300, I want the vlookup to change it's search
range automaticly to this new range
My formula is =vlookup(+c11;+c12;3;false) and c11=206 and c12=tabel2300
--
Greetz
Kris

vlookup in several sheets
 

Try this......

=VLOOKUP(C11,INDIRECT(C12),3,FALSE)

Where the value to be looked up is in C11 and the name of the preferred
Range is in C12.......

Vaya con Dios,
Chuck, CABGx3



"kris" wrote:

Hi
I want to make the range in my vlookup formula variable. If for example I
use the account from 2200 into 2300, I want the vlookup to change it's search
range automaticly to this new range
My formula is =vlookup(+c11;+c12;3;false) and c11=206 and c12=tabel2300
--
Greetz
Kris

vlookup in several sheets
 

Assuming that C12 contains a named range, try...

=VLOOKUP(C11,INDIRECT($C$12),3,FALSE)

Replace commas with semi-colons if your version of Excel uses a
semi-colon as a list separator.

Hope this helps!

In article ,
"kris" wrote:

Hi
I want to make the range in my vlookup formula variable. If for example I
use the account from 2200 into 2300, I want the vlookup to change it's search
range automaticly to this new range
My formula is =vlookup(+c11;+c12;3;false) and c11=206 and c12=tabel2300