software

I have a matrix of data with headers at first row and first column.
some rows below I have put in on of the row header and column header.
whenever i change the row and column header, I should get the right
data coresponding the header row and header column.
e.g.

let this be the data :
29/04/200630/04/200601/05/200602/05/200603/05/200604/05/200605/05/2006
a53175389353434453
b3517873453456753
c315351782734534475345
d72257873353433
e72742434423
f242731422442
g55454542347275634
h5672453254763
i735345323742
j56389745456334

so when i type date 29/4/2006 in cell b20 and quot;jquot; in cell a21, I
should get the value 56 in cell b21. I hope I was clear in explaining
my problem. there is a combination of function using match and index
functions to solve this but i do not remember that somehow .. please
help me..--
vishal
------------------------------------------------------------------------
vishal's Profile: www.excelforum.com/member.php...foamp;userid=5327
View this thread: www.excelforum.com/showthread...hreadid=537421=INDEX(A1:H11,MATCH(A21,A1:A11,0),MATCH(B20,A1:H1, 0))

Assuming that your table (as it's written) starts at A1.

Ian

quot;vishalquot; wrote:

gt;
gt; I have a matrix of data with headers at first row and first column.
gt; some rows below I have put in on of the row header and column header.
gt; whenever i change the row and column header, I should get the right
gt; data coresponding the header row and header column.
gt; e.g.
gt;
gt; let this be the data :
gt; 29/04/200630/04/200601/05/200602/05/200603/05/200604/05/200605/05/2006
gt; a53175389353434453
gt; b3517873453456753
gt; c315351782734534475345
gt; d72257873353433
gt; e72742434423
gt; f242731422442
gt; g55454542347275634
gt; h5672453254763
gt; i735345323742
gt; j56389745456334
gt;
gt; so when i type date 29/4/2006 in cell b20 and quot;jquot; in cell a21, I
gt; should get the value 56 in cell b21. I hope I was clear in explaining
gt; my problem. there is a combination of function using match and index
gt; functions to solve this but i do not remember that somehow .. please
gt; help me..
gt;
gt;
gt; --
gt; vishal
gt; ------------------------------------------------------------------------
gt; vishal's Profile: www.excelforum.com/member.php...foamp;userid=5327
gt; View this thread: www.excelforum.com/showthread...hreadid=537421
gt;
gt;

Hi Vishal,

Something like

=INDEX(B2:H11,MATCH(B21,A2:A11),MATCH(B20,B1:H1))

But you have to correct the arrays..

Regards,
Bondi
Hi Ian and Bondi,

Thanks a lot, your suggestions did work. I have got the solution.
regards,
Vishal--
vishal
------------------------------------------------------------------------
vishal's Profile: www.excelforum.com/member.php...foamp;userid=5327
View this thread: www.excelforum.com/showthread...hreadid=537421