vlookup on changing range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yossi evenzur - 23 Jan 2008 01:11 GMT

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?

Reply to this Message

ryguy7272 - 23 Jan 2008 21:04 GMT

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

Signature

RyGuy

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

Reply to this Message