How could I do automatically find the price

Closed
Damir - Aug 16, 2016 at 06:05 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 16, 2016 at 07:48 AM
Hello,


I have question for Excel, it is small hotel booking system?

If I have for example 6 rooms, and they have all different prices, i.e. 100-600, and different dates so low season for room 1 is 100, high 200; room 2 200-300, room 3 300-400, how could I do automatically find the price?

Thanks

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 16, 2016 at 07:48 AM
Damir, Good morning.

I suggest you to use a VLOOKUP function or an INDEX + MATCH combination of functions.

I did a little example for you:
http://speedy.sh/Xa65Y/16-08-2016-en-Kioskea-Hotel-Booking-Example-OK.xlsx

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1