Forum Discussion
BIG BIG HELP!
The below is the source range of data : ROW : Single occupancy Double occupancy COULMN: Hotel A : 100 200 Hotel B : 200 250 ...
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)
