Sub: extract data from one excel worksheet to another worksheet

Sir,
Sub: extract data from one excel worksheet to another worksheet
I have a model excel sheet enclosed. The table has a list of shares and their price range for a single day split into various price levels.
Now I request a formula to do the following;
In answer sheet1, I request that as I enter the level of any share, it should capture the corresponding price relating to that share from sheet 1 as illustrated;
Likewise In answer sheet2, I request that as I enter any price of any share, it should capture the corresponding level relating to that share from sheet 1 as illustrated;

Thanks in advance
vks1964

On "Answer1" sheet, in C2, you can enter this:
=INDEX(Sheet1!$B$2:$H$8,MATCH(answer1!A2,Sheet1!$A$2:$A$8,0),MATCH(answer1!B2,Sheet1!$B$1:$H$1,1))
And then copy it down.

On Answer2 sheet, in C2 you can enter this:
=INDEX(Sheet1!$B$1:$H$1,1,MATCH(answer2!B2,Sheet1!B2:H2,1))
and copy it down.

Originally Posted by Gregb11

On "Answer1" sheet, in C2, you can enter this:
=INDEX(Sheet1!$B$2:$H$8,MATCH(answer1!A2,Sheet1!$A$2:$A$8,0),MATCH(answer1!B2,Sheet1!$B$1:$H$1,1))
And then copy it down.

On Answer2 sheet, in C2 you can enter this:
=INDEX(Sheet1!$B$1:$H$1,1,MATCH(answer2!B2,Sheet1!B2:H2,1))
and copy it down.

Thanks sir! It works