Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us