I have been looking at formulas to figure out how to solve my problem, but have nothing yet. My spreadsheet is used for Fantasy Football. I have a worksheet that contains, by row, all the teams and associated player names according to position (column headings). I have another worksheet that contains my ranking of teams (1-32) with the team name (same as in worksheet 1, but different order). When I mark a team taken on worksheet 1 (I have a second column that I use to indicate a team/player is chosen), I want the formula to search through the range of names in worksheet 2 and when matched, mark the name (strikethrough or color) indicating that it is taken.
Example is:
worksheet 1 has all the 32 NFL team names in an order
worksheet 2 has all the 32 NFL teams names in a range determined by some criteria (not in the same order as they are in worksheet 1)
When I mark a team has been selected in worksheet 1, I want the formula to match the NFL name from worksheet 1 in the range of NFL names in worksheet 2 and when it matches to strikthrough (or make the cell a color, some way to indicate the the team has been selected) the name.
I am continuing to research, but any help would be appreciated. Thanks.
Bookmarks