Hi,
I have a cell range, that I have explicitly named Round1.
I am using vlookup to select certain data from this range. Currently the formula looks like this:
=VLOOKUP($A$1,Round1,2,FALSE)
Is there a way to select this range without having to manually type in Round1 into the second parameter. For example, if I enter "Round1" into cell C1, would there be a way to make this formula work:
=VLOOKUP($A$1,C1,2,FALSE)
I know the above formula wouldn't, but is there some other way that i could link the second parameter to some cell and produce the range I am looking for?
Thanks
Bookmarks