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
|