Forum Discussion
BIG BIG HELP!
Hi Benazir,
Better if you attach small file with example as in your post for better understanding how is your data structured and where you'd like to have the result. And it will be easier to answer not generating your model from scratch.
Thank you
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.