I'm just beginning to learn advanced points of Excel and wanted to enlist your help. For the life of me I can't figure out how to return a text cell using an IF statement, like the old Basic days of IF, THEN.

For example, I'm building a baseball lineup card than has multiple listings of players. E.g.: Smith, John 3B, Jones, Josh SS, Van Hausen, Mark CF, etc. The positions "3B", "SS" and "CF" are in different cells than the names "Smith, John", "Jones, Josh" and "Van Hausen, Mark". On the same lineup card spreadsheet, I have the defenses laid out and want to return the corresponding name up to the comma only at 3B. I haven't had any luck getting any name to return by using arrays and the IF function.

So, again, my goal is to have "Smith" yielded next to my "3B" cell, "Jones" next to my "SS" cell and "Van Hausen" next to my "CF" cell. Any thoughts?