Hello,

Hope you are all well. I've been racking my brains on how to solve this problem and I sadly my brain simply isn't up to the challenge. I run a small travel company and I want to set up a "hotel price calculator" on excel. On the back tabs I have a list of months (may, june, july etc), a list of hotels and a list of room grade (standard, suite etc) and finally a price for every single potential outcome.

Ultimately I want to be able to select a Month, followed by a hotel, followed by room grade and then for the price recorded on the back tabs for that criteria, to automatically appear.

Any help would be hugely appreciated.

Many thanks,

James