hello excel gurus,

I'm having issues with looking up a table and returning a value from the very first cell of the corresponding row. I tried using Index/match, but it is limited to the Column references. For example, I have the following two tables. Thanks in advance. Please help!

Table 1
Row A B C D
ABC 1 2 3 4
DEF 5 6 7 8
GHI 9 10 11 12

Table 2 Desired values
1 ABC
2 ABC
3 ABC
4 ABC
5 DEF
6 DEF
7 DEF
8 DEF
9 GHI
10 GHI
11 GHI
12 GHI

Thanks.