cineam lookup if problem????
 

Hi All,
Hope you are all keeping well.

My problem is as follows:
Each Day has a worksheet with tab named for that day and one extra sheet
labelled "addstrailers"

In the day sheets eg "Thursday"
there are 5 columns as follows
Screen Start Turret Finish Film Title


on the "addstrailers" sheet
there are also 5 columns
Screen Adds Trailers Total Film Title


what im trying to do is have a lookup/if statment in the Turret field
something like this:
in day sheet in C2 (turret) =if A2 (screen) AND E2 (Film Title) find exact
match in addstrailers sheet then make Turret field (which is in Time format)
= Start (time) from Day sheet +Total (Time) from addstrailers

I hope ive made that clear, its really been doing my head in. Thanks for any
help that can stop me reaching for some rope

--
Best Wishes
John
www.celticfringe.co.uk
www.bagpipermusic.co.uk

Solution
 

The solution i came up with was using 3 named ranges - Screen - Title -
Total
then using an array
=INDEX(total,MATCH(B5,IF(title=G5,screen),0))
hope others may find this useful
Best Wishes
John
www.celticfringe.co.uk
www.bagpipermusic.co.uk

"John McFadden" wrote in message
...
Hi All,
Hope you are all keeping well.

My problem is as follows:
Each Day has a worksheet with tab named for that day and one extra sheet
labelled "addstrailers"

In the day sheets eg "Thursday"
there are 5 columns as follows
Screen Start Turret Finish Film Title


on the "addstrailers" sheet
there are also 5 columns
Screen Adds Trailers Total Film Title


what im trying to do is have a lookup/if statment in the Turret field
something like this:
in day sheet in C2 (turret) =if A2 (screen) AND E2 (Film Title) find exact
match in addstrailers sheet then make Turret field (which is in Time
format) = Start (time) from Day sheet +Total (Time) from addstrailers

I hope ive made that clear, its really been doing my head in. Thanks for
any help that can stop me reaching for some rope

--
Best Wishes
John
www.celticfringe.co.uk
www.bagpipermusic.co.uk