Vlookup - issue

Dear all

I hope you would help me out, i do not understand why the Vlookup in the file is not working

I try to look for the room type by hotel but fail

Appreciate your help

Eric

In C18 and copy down:

Formula:

Please Login or Register  to view this content.

BSB

OR

Sort the hotels in B3:B11 in Ascending (A to Z) order.