LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 4
Default Using Intersecting Values on another sheet

I'm really stuck on a problem.

I have a workbook with 2 sheets.

Sheet 1 consists of 4 columns Job Ref, Type, Q & Days
The 1st contains reference which is used to track tasks.
The 2nd contains the type of job (one of a list of 13 for each Job Ref)
The 3rd contains the Q (which is equivalent to a Q in which the job is picked up from. There are 6 Qs each job CAN pass through)
The 4th column holds N°s for max N° of days a job should spend in each of the Qs (this is determined by lookup of the data within the table on Sheet 2

Sheet 2 consists of a Grid. With columns 'Type', 'Planning', 'Bandwidth', 'Quality', 'Delivery', 'Optimisation', 'NAM', 'NOM' & 'Closing'.
The 1st Column (headed 'Type'), contains the list of the jobs 'types' (of which the 1st 3 characters are N°s ie 801.., 802.. etc)

I need a formula to put the N°'Days' in sheet 1, from the intersection of the top row values with those in the far left column.
Please see example spread sheet 'Profiles.xlxs'

Thanks
Attached Files
File Type: zip Profiles.zip (11.6 KB, 43 views)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Intersecting Data kojak Excel Programming 1 June 2nd 06 04:39 PM
copy values generated by conditional formula in one sheet to the other work sheet as values bobby Excel Discussion (Misc queries) 1 October 5th 05 12:18 PM
Value at Intersecting cells Wild Bill[_2_] Excel Programming 0 August 28th 03 04:29 AM
Value at Intersecting cells Leo Heuser[_2_] Excel Programming 0 August 27th 03 02:09 PM
Value at Intersecting cells Chip Pearson Excel Programming 0 August 27th 03 02:00 PM


All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"