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

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

Thank You Claus. You solution was spot on! You have won the day !!!