Hello:
A - B - C - D - E - F
1 - Data 2003 2004 2005 2006 2007
2 - DE 57 61 64 65 65
3 - MD 55 59 62 62 62
4 - NJ 47 47 47 47 48
5 - NY 37 40 41 39 39
6 - PA 41 43 45 46 48
I have the data arranged as above:
I need only selected values such as
cell I1: 2004
cell H2: DE ????
I write the following array function:
{=INDEX($C$2:$C$6,MATCH($H2&I$1,$A$2:$A$6&$B$1:$F$1,0))}
It gives me #N/A in stead of the actual value 61 - in cell C2.
What is the mistake
Thank you.
Subbu
[email protected]
Bookmarks