vlookup on changing range
 

Hi
I need to the syntax for running a Vlookup on a fixed array, but each time
the size of the array is changing. is there any command for this or can i use
a variable that will stand for range each time?

vlookup on changing range
 

Well, I think you can just use the entire range, right.

=VLOOKUP(A1,$A:$B,2,FALSE)


Maybe you are talking about a dynamic range... Check these out:
http://www.ozgrid.com/Excel/DynamicRanges.htm
http://www.contextures.com/xlNames01.html
http://www.contextures.com/xlNames02.html

Regards,
Ryan--


--
RyGuy


"Yossi evenzur" wrote:

Hi
I need to the syntax for running a Vlookup on a fixed array, but each time
the size of the array is changing. is there any command for this or can i use
a variable that will stand for range each time?