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
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
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
Related:
- How could I do automatically find the price
- Download automatically while roaming - Guide
- Why does facebook refresh itself automatically - Guide
- How to stop idm from automatically downloading - Guide
- How to automatically save photos from messenger to gallery - Guide
- How to refresh outlook inbox automatically - Guide
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
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
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