I have a column on different worksheets in the same workbook. One worksheet has a roster of players down one column on another column on a different worksheet there is a list of players with there salaries in a different cell.
I would to know if there is a formula that would return the salary if the player was in both lists.
I would to know if there is a formula that would return the salary if the player was in both lists.