Good morning all,
I have a requirement to do a lookup, which i believe might need a 3d function. 
I have a spreadsheet that has multiple tabs that depict different areas in various applications. And one tab that has a list of requirements. Within the various application tabs, against each line item I have the requirement it is mapped to. What I am looking to do is in the requirement tab, have one column that has list of all the applications that are mapped to this requirement. An example is as below - the last table depicts what the resultant output should look like (in the bolded column):
Application A tab:

Application B tab:

Application C tab:

Requirements Tab: (desired result)