Try this:

=VLOOKUP(A5,INDIRECT(B3),FALSE)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"nir020" wrote:

I am trying to creat a vlookup formula that instead of using range for its
table array will reference a cell which contains a range.

It will therefore look something like this:-

=VLOOKUP(A5,B3,FALSE)

where the cell B3 contains something like: 'a1:a100' but it is not working,
can you suggest a soloution?