I have this table in a spreadsheet.

a b c d e f g
1 1 2 3 4 5 6
2 A Z U P K F A
3 B V Q L G B
4 C W R M H C
5 D X S N I D
6 E Y T O J E

Below is what i need have displayed.

a b c d
7 J U M P
8 E5 A2 C4 A3

So i need to use the first grip to make up the answers in second in row 8.

I can use the concatenate to get the Letter and number together, however i
dont know how to get the letters and numbers. I used the lookup however it
only worked for the first row and the rest of the rows dont work? help on
this would be great!!