Hi guys,
I've asked this before but can't get anything to work - any suggestions?
I have one workbook with 2 worksheets in it.
First worksheet - called SS IDLE, cell D3 contains the text '1: (LUNCH) LUNCH' and cell B5 contains the text 'Smith, John'. Using data from the second worksheet I want to populate cell D5 with the length of time John was on lunch - i.e. 00:45:00.
Second worksheet - called IDLE, column P contains a list of different codes, some of which are '1: (LUNCH) LUNCH'. Column Q contains a list of names, some of which are 'Smith, John' and column R contains the length of time.
I need cell D5 on my first worksheet to look in column R on my second worksheet and return the time when column P says '1: (LUNCH) LUNCH' and column Q says 'Smith, John'. There will only be one cell that provides this data.
I hope that makes sense - can't post using the html thing to show an example of the spreadsheet so have to rely on my limited descriptive skills.
I've asked this before but can't get anything to work - any suggestions?
I have one workbook with 2 worksheets in it.
First worksheet - called SS IDLE, cell D3 contains the text '1: (LUNCH) LUNCH' and cell B5 contains the text 'Smith, John'. Using data from the second worksheet I want to populate cell D5 with the length of time John was on lunch - i.e. 00:45:00.
Second worksheet - called IDLE, column P contains a list of different codes, some of which are '1: (LUNCH) LUNCH'. Column Q contains a list of names, some of which are 'Smith, John' and column R contains the length of time.
I need cell D5 on my first worksheet to look in column R on my second worksheet and return the time when column P says '1: (LUNCH) LUNCH' and column Q says 'Smith, John'. There will only be one cell that provides this data.
I hope that makes sense - can't post using the html thing to show an example of the spreadsheet so have to rely on my limited descriptive skills.
ray: 
