Can I use a formula/cell value to determine the starting point of a range?
for example:
In excel - I type "B4" into cell C1
if I have a formula:
=vlookup(A4,B1:B5,1,false)
can I replace the starting point of this range (namely 'B1') with the result of C1 making the formula effectively...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.