Google Sheets: Opposite of HLOOKUP, is it possible?

[p_s]

Player Name	Anne	Cathy	Paul	Jimmy	Suzanne	Bobby
Roll #	2	5	1	6	3	4
Random Roll:	=RANDBETWEEN(1,6) (Assume Number it rolls is 5)		The winner is=	Cathy

Is there a way we can reverse lookup Row 2, to look up Row 1?



I used the formula, to make Row 2 the 1st row.

=HLOOKUP($E$4,{A2:G2;A1:G1},2,false)

 

[RoryA]

In Excel you'd use:

=INDEX(A1:G1,MATCH($E$4,A2:G2,0))

which I think should work in Sheets too.