Extract data from sheet

I have the table below and would like to extract the room nights and the room revenue per month to another sheet. What formula do I put in the other sheet to look for the data in this sheet?

 




















Name   Jan Feb Mar Apr
MORNING STAR          
  Room Nights 50 10 3 0
  Room Revenue $6,450.00 $1,290.00 $387.00 $0.00
  Total Revenue $6,673.75 $1,376.25 $432.00 $0.00
  Average Daily Rate $129.00 $129.00 $129.00 $0.00
  Average LOS 3.45 3.64 4.00 0.00
  Room Night % Contribution 2.36% 0.59% 0.15% 0.00%
PRICELINE OPAQUE          
  Room Nights 10 14 18 21
  Room Revenue $790.00 $1,106.00 $1,422.00 $1,659.00
  Total Revenue $805.24 $1,156.00 $1,574.50 $1,715.99
  Average Daily Rate $79.00 $79.00 $79.00 $79.00
  Average LOS 1.67 1.75 2.25 1.56
  Room Night % Contribution 0.47% 0.82% 0.89% 1.00%

 

By: Ewan

Leave a Reply

Your email address will not be published. Required fields are marked *