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

Deprecated: Increment on non-numeric string is deprecated, use str_increment() instead in /home/ihlamberhl/devcnja/samples/LookupRef/VLOOKUP.php on line 43
I4: =VLOOKUP(I3, B3:E9, 2, FALSE) & " " & VLOOKUP(I3, B3:E9, 3, FALSE) => James Anderson
I5: =VLOOKUP(I3, B3:E9, 4, FALSE) => 70855

Deprecated: Increment on non-numeric string is deprecated, use str_increment() instead in /home/ihlamberhl/devcnja/samples/LookupRef/VLOOKUP.php on line 43
J4: =VLOOKUP(J3, B3:E9, 2, FALSE) & " " & VLOOKUP(J3, B3:E9, 3, FALSE) => Mark Reed
J5: =VLOOKUP(J3, B3:E9, 4, FALSE) => 125180

Deprecated: Increment on non-numeric string is deprecated, use str_increment() instead in /home/ihlamberhl/devcnja/samples/LookupRef/VLOOKUP.php on line 43