Need a solution for a complex excel live report

Data point Page 1
Customer Subscription number XXXXXX

Typing in this number bring up details about the customers subscription from other pages

Information needed.
Company name (This information will be manually entered on a different page)
Company phone (This information will be manually entered on a different page)
Company email (This information will be manually entered on a different page)

Subscription Start date.(This information will be manually entered on a different page)

Rentals
Start date/time, end date/time, customer, number of days. (This information will be manually entered on a different page)
"" ""
"" ""

Active rentals
(this number needs to reflect the number of active rentals above and cannot display more than 3.. ie if a rental above is from march 8 to march 10 it is currently active meaning Active rentals is 1. on the 11th of March the rental is finished and active rentals would be 0.

Remaining rental days.
Each month a customer is allowed rent upto the number of days in a month ie 30 or 31 depending. this count will start from their subscription date and be calculated by the start date/time and end date/time. whils the customer may have up to 3 cars on rent at any one time the total number of days for those cars cannot exceed the number of days in the month. Remaining days should show the amount of rental days remaining and turn red and show negative if they exceed this.

Hope this makes sense…

Link http://www.excelforum.com/showthread...=1#post4334243

Thanks for the change

(you could probably do this with VLOOKUP or INDEX/MATCH)

Could you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Ben, try this
=IFERROR(IF(INDEX(Employees!$B$4:$D$27,SMALL(IF(Employees!$B$4:$B$27=Overview!$B$1,ROW(Employees!$B$4:$B$27)),ROW(1:1))-3,3)=0,"",INDEX(Employees!$B$4:$D$27,SMALL(IF(Employees!$B$4:$B$27=Overview!$B$1,ROW(Employees!$B$4:$B$27)),ROW(1:1))-3,3)),"")

thyzt, if that was what you wanted too, then great, if not, you need to start your own thread.[/B]

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.