Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup problem | Excel Worksheet Functions | |||
lookup problem | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions | |||
HELP -- probably a LOOKUP problem | Excel Discussion (Misc queries) |