Hi,
There has to be a better way than the one I am about to show, but it seems
to work, so it'll do for starters.
Lookup number in G1
You'll need 4 helper cells. I've used G2, H2, I2, J2
G2 =MATCH($G$1,A:A,0)
H2 =MATCH($G$1,B:B,0)
I2 =MATCH($G$1,C:C,0)
J2 =MATCH($G$1,D:D,0)

G2 =INDIRECT("E"&SUMIF(G2:H2:I2:J2,"0"))
G2 returns the text you want.
I tried to include the 4 Match formulas inside a single SUMIF, but couldn't
get it to work. Perhaps one of the pro's will enlighten us.
Regards - Dave.