Excel 2003 - Data extract

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