You have a space at the end of Ramada Hotel in cell B8, so I suggest your remove that, and then you can use this formula in D8:

=INDEX($C$4:$G$5,MATCH(TRIM($B8),$B$4:$B$5,0),MATCH(D$7,$C$3:$G$3))

then you can copy this across into E8:F8.

The TRIM function (shown in red) is only needed if you don't remove the space in B8.

Hope this helps.

Pete