Vlookup Data From 1 sheet to another

[emperorgenghiskhan]

I inherited a pre-made worksheet which worked fine for me until I need to add another column of data to the information page that I need called back to page 2.

The current vlookup formula is
=IF(NOT(ISBLANK(C4)),IF(MID(C4,2,1)= "-",UPPER(VLOOKUP(C4,Team!$B$8:$D$12,2,FALSE)) & " " & UPPER(VLOOKUP(C4,Team!$B$8:$D$12,3,FALSE)),UPPER(VLOOKUP(VALUE(C4),Team!$B$8:$D$12,2,FALSE)) & " " & UPPER(VLOOKUP(VALUE(C4),Team!$B$8:$D$12,3,FALSE))),"")
this looks up data based on a criteria ("age" in the test sheet) and returns a merged value for 2 columns ("system" and "name" in the test sheet).

I have added a new column ("home" in the test sheet) and want to have that looked up using the same criteria used to look up the other information. I cannot for the life of me figure what part of the formula to edit.

I added a test sheet and images to explain since I am sure I did not explain my self well.

UPxTf7H.jpg

9SnNXor.jpg

[Bo_Ry]

Please try at
E3
=IFERROR(INDEX(Team!$E$8:$E$12,MATCH(C3,Team!$B$8:$B$12,)),"")

D3
=IFERROR(INDEX(UPPER(Team!$C$8:$C$12&" "&Team!$D$8:$D$12),MATCH(C3,Team!$B$8:$B$12,)),"")

[emperorgenghiskhan]

Please try at
E3
=IFERROR(INDEX(Team!$E$8:$E$12,MATCH(C3,Team!$B$8:$B$12,)),"")

D3
=IFERROR(INDEX(UPPER(Team!$C$8:$C$12&" "&Team!$D$8:$D$12),MATCH(C3,Team!$B$8:$B$12,)),"")

Thank you this worked perfectly