Hi Guys, first off - Happy New Year to everyone!
I am trying to use multiple criteria in an Excel Invoice for a friend, however, I am stuck now because I have confused myself so much watching videos on Index and Match...
I have multiple criteria (of course)...
- There are multiple room Types A, B, B1, C, D and E (Dropdown)
- And each Room Typ and has either 1, 2 or 3 Person Prices (Table)
- These price DEPEND on number of nights (7-14, 15-27 and 28+)
- And additionally there is the type of Stay (Boarding Type) - Room Only, Bed and Breakfast and Half board (Dropdown) which in turn using IF statement returns the additional price for either Breakfast or Half-Board
So I did a MATCH for Room Type, an Amount given from a CELL containing Number of Persons, a MATCH for the Number of Nights (caclulated from arrival and departure date) and a MATCH for the Boarding Type - so now I have for example:
Typ A, 2 Persons, 17 Nights with Halfboard... how do I formulate the answer out of the MATCHES? Or am I am the wrong track?
Any help is greatly appreciated - Cheers
Lee
I am trying to use multiple criteria in an Excel Invoice for a friend, however, I am stuck now because I have confused myself so much watching videos on Index and Match...
I have multiple criteria (of course)...
- There are multiple room Types A, B, B1, C, D and E (Dropdown)
- And each Room Typ and has either 1, 2 or 3 Person Prices (Table)
- These price DEPEND on number of nights (7-14, 15-27 and 28+)
- And additionally there is the type of Stay (Boarding Type) - Room Only, Bed and Breakfast and Half board (Dropdown) which in turn using IF statement returns the additional price for either Breakfast or Half-Board
So I did a MATCH for Room Type, an Amount given from a CELL containing Number of Persons, a MATCH for the Number of Nights (caclulated from arrival and departure date) and a MATCH for the Boarding Type - so now I have for example:
Typ A, 2 Persons, 17 Nights with Halfboard... how do I formulate the answer out of the MATCHES? Or am I am the wrong track?
Any help is greatly appreciated - Cheers
Lee