Single cell to provide multiple =IF functions

Rexmoore is in cell G25,
F25 = 08 Doors, Frames, HW
F44 = 16 Electrical
Kraemer Electrical isn't in the list. Column G has 31 rows vs column F with 44, there seems to be no relationship between the two.

Hey Ben,

Yeah, I was just giving an example. currently in the spreadsheet I attached, E33 says PDCI. I would like cells F33 and G33 to auto input the information that is currently there for the future blank cells. I manually input those words in my spreadsheet. The idea was to take that same formula and input the formula into the blank cells below that are not being used yet so that when I select any of those names from the dropdown list in column E.. columns F and G will automatically input the Disciplines and EOR Reviewers. Summary- I want values in column E to impact what columns F and G show.

Example;

E33 (dropdown List manual input)---------F33 (Formula Inputs)--------------G33 (Formula Inputs)
PDCI---------------------------------------------09 - Concrete Finishes --------------------HPA

But if I select a different name from the dropdown in E33 everything changes to a different input.. example;

E33 (dropdown List manual input)--------------F33 (Formula Input)--------------G33 (Formula Input)
Airtower--------------------------------------------------21 Fire Alarm---------------------------HGI