Try this.

Used indirect function.

=OFFSET(INDIRECT(ADDRESS(1,MATCH($A3,$A$1:$HO$1,0))),1,0)
Regards,
Suhas