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
Bookmarks