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