ExcelBanter - If then problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If then problem (https://www.excelbanter.com/excel-worksheet-functions/132311-if-then-problem.html)

I have a baseball roster for our entire league. I want to be able to enter
in the coach's name and have the team name displayed in another cell. I have
tried this on a smaller scale and got it to work, but now with all the names
(95) it doesn't return anything in the cell. Below is an example of the
cells:

A B C D E F
1 # last first Coach Team avg
2 50 Smith B Manny 28.00
3 99 Jones Y Chuck 27.50

On a separate sheet (Sheet2) I have a list of 9 coach and team names in
columns A and B

The formula I was trying to use in the Team cells is:
=IF(D2=Sheet2!A1:A9,Sheet2!B1:B9,"")

Any suggestions?

one way:

=VLOOKUP(D2,Sheet2!$A$1:$B$9,2,FALSE)

In article ,
dodgers32 wrote:

I have a baseball roster for our entire league. I want to be able to enter
in the coach's name and have the team name displayed in another cell. I have
tried this on a smaller scale and got it to work, but now with all the names
(95) it doesn't return anything in the cell. Below is an example of the
cells:

A B C D E F
1 # last first Coach Team avg
2 50 Smith B Manny 28.00
3 99 Jones Y Chuck 27.50

On a separate sheet (Sheet2) I have a list of 9 coach and team names in
columns A and B

The formula I was trying to use in the Team cells is:
=IF(D2=Sheet2!A1:A9,Sheet2!B1:B9,"")

Any suggestions?