In excel i want to compare cell values and get another cell value

(attached the file) I want to compare Sheet1 value with other sheets(TeamA,TeamB) ID value , if sheet1 ID = TeamA /TeamB sheet field ID then i want to get the correct category value related to that ID:

from other sheets(TeamA,TeamB)