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