Originally Posted by Claus Busch

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