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