vlookup in several sheets

K

kris

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
 
C

CLR

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
 
D

Domenic

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!
 
Top