How could I do automatically find the price

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month