vlookup on changing range

[Yossi evenzur]

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?

 

[ryguy7272]

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