Pull data from certain columns based upon a specifics within another column

[EmilAlteryx01]

What is the best way to pull data from certain columns based upon a specifics within another column - attached is my output sample.
2) I am trying to recreate a "Table" in alteryx, essentially doing a lookup on columns F6-K6 using data from the "E" column.
2) My Excel has =IF(ISNUMBER(FIND($E$10,$G$6)),"-","NOT APPLICABLE") as well