Here's what I'm trying to do.

I have several columns of data. I would like to search one of those columns
(a range) for a specific value. If that value is found I want to output the
value of the cell that is to the left of the cell where the search value was
found, on another sheet.

On Sheet 1
Column 1 is a list of 26 baseball players. Column 2 is their position.

I want to search thru column 2 for a specific position, lets say "c" for
catcher. If "c" is found I want the cell to the left of the "c" (the players
name) to out put on Sheet 2.

On Sheet 2
Is a baseball diamond, and I want the name to appear in the place on the
diamond I choose.

So basically I need a formula to place in a particular cell on Sheet 2 that
looks thru the data on Sheet 1 in the way explained above.

Thanks,
-paul