Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Intersecting Values on another sheet
Hi,
Am Tue, 30 Dec 2014 07:06:45 +0000 schrieb greenemm: 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. in Sheet1 D2: =INDEX(Sheet2!$A$1:$I$14,MATCH(B2,Sheet2!$A$1:$A$1 4,0),MATCH(C2,Sheet2!$A$1:$I$1,0)) and copy down. Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Intersecting Data | Excel Programming | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
Value at Intersecting cells | Excel Programming | |||
Value at Intersecting cells | Excel Programming | |||
Value at Intersecting cells | Excel Programming |