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