Thanks, I will try and get back to you.

Jeff

"Duke Carey" wrote:

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