Forum Discussion
BIG BIG HELP!
Hello Mr Sergei and thank you so much for your speedy revert.
PFA as requested!
Thank you. And in your first post you mentioned number of nights, i didn't find in the file. Did i miss?
Please note that this is not where I am stuck as I can build on the formula.
Where I need help is:
- If the hotel picked up from my lookup list if "Hotel 1", the data relating to my formula (which I can solve) should only be picked up from the line of "Hotel 1 " (or ROW 2)
Okay, without the nights, just rate will be
=INDEX($B$1:$C$5,MATCH($D8,$A$1:$A$5,0),2-($C8>1))
In you real file ranges are to be
- instead of $A1:$A$5 you entire hotels list, better with gap in rows if you add hotels (or just $A:$A but that affects the performance);
- instead of $B$1:$C$5 related range for prices.
So please find attached the actual data sheet.
I have built on the formula, however I am stuck with a conditional format that the data for the formula should only take data from the row corresponding to the hotel in question
Benazir,
are you looking for this:
=VLOOKUP(D8,$A$2:$C$5,C8+1)
So please find attached the actual data sheet.
I have built on the formula, however I am stuck with a conditional format that the data for the formula should only take data from the row corresponding to the hotel in question
So I have amended the file with a few more data to be a little more clearer.
I am not stuck on the formula to calculate ....I just need to ensure that when the Hotel selected is "Hotel 1", the formula should only relate to all the values available to Hotel 1 only.
