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?