Give the range Sheet1!B2:N53 the name of the county, e.g., "Cuyahoga"
Then, if the word Cuyahoga is in cell A1, use
=VLOOKUP(F12,INDIRECT(A1),2)
"jsteele" wrote:
I am using the following lookup function to return a value. I am currently
using one sheet for the values. I need to be able to use a number of sheets
representing different counties and values. The formula looks like this
=VLOOKUP(F12,Sheet1!B2:N53,2)
I would like to be able to vary the Sheet1 to be different counties and
equal a cell where the user would imput the county name. The sheets would be
named the same.
Can this be done??
Jeff
|