software

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

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
quot;krisquot; wrote:

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

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 gt;,
quot;krisquot; gt; wrote:

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