depends on how the result is determined.
For instance, if the return is a cell then Cell.Column
could be used

Worksheets(Cell.Column-1).Activate

Otherwise if the result is simply the column number

Worksheets(FoundColumn-1).Activate

If its a letter (A,B...) then
Worksheets(ASC(ColLetter)-65).Activate

...."A" is ASCII 65 so B is 66 hence if B is passed
ASC("B") - 65 = 1


HTH
PAtrick Molloy
Microsoft Excel MVP

-----Original Message-----
How would I go to Sheet1, Sheet2 or Sheet3 in a database
of names with
32 rows, 17 columns? If a name I find a match for is in
Column B, go
to Sheet1, if a name is in Column C go to Sheet2, etc.
(I need to
start from Column B) My lookup value will be a name, not
a cell
reference. Thanks.
.