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
Hotel C : 300 350
Now I enter customer details as under in the below column and row as:
Mr X on single occupancy Stays in Hotel A for 12 nights
So the conditional formula needs to pick up as :
= HOTEL A (100 X 12 nights)
Please help!!!!!
13 Replies
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?
