Report Offensive Message

Use a count function inside of the HLookup so that you don't have to manually enter the row that you want the data returned. Applying the absolute constrain on the begining of the table but not the end allows the formula to be draged down.
=HLOOKUP($E$2,$B$2:$D$5,COUNT($E$2:E3)+1)