Excel 2003 - Data extract

**rajthapa** · 07-02-2011, 08:54 AM

I have a table with rows and columns. See below.

Number 1 2 3 4 5
1 1 1 1 1 1
2 2 4 8 16 32
3 3 9 27 81 243
4 4 16 64 256 1024
5 5 25 125 625 3125

Input row = x
Input coloumn = y

Answer = ?

If I input row as 5 in x and coumn as 2 in y, in the answer cell the result should appear as 25. The answer cell should not contain formula.

What is the solution for the above. Do we use of Vlookup, Index and Match etc. Please provide the solution.

**jeffreybrown** · 07-02-2011, 09:48 AM

Hello & Welcome to the Board,

Originally Posted by rajthapa

The answer cell should not contain formula.

I don't understand this part other than you would need code. Is this what you want?

Originally Posted by rajthapa

Do we use of Vlookup, Index and Match etc. Please provide the solution.

An Index/Match will work

=INDEX($B$2:$F$6,MATCH($H$1,$A$2:$A$6,0),MATCH($I$1,$B$1:$F$1,0))

H1 = 5
I1 = 2

**rajthapa** · 07-04-2011, 02:20 PM

Thanks Jeff for the reply. Let me try it out. Sorry for the delay.

Regards,

Yes it worked. Thanks a lot once again.

**jeffreybrown** · 07-04-2011, 03:25 PM

Glad it worked for you and thanks for the feedback

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save