VLOOKUP

Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.
H4: =VLOOKUP(H3, B3:E9, 2, FALSE) & " " & VLOOKUP(H3, B3:E9, 3, FALSE) => Jessica Walker
H5: =VLOOKUP(H3, B3:E9, 4, FALSE) => 58339
I4: =VLOOKUP(I3, B3:E9, 2, FALSE) & " " & VLOOKUP(I3, B3:E9, 3, FALSE) => James Anderson
I5: =VLOOKUP(I3, B3:E9, 4, FALSE) => 70855
J4: =VLOOKUP(J3, B3:E9, 2, FALSE) & " " & VLOOKUP(J3, B3:E9, 3, FALSE) => Mark Reed
J5: =VLOOKUP(J3, B3:E9, 4, FALSE) => 125180