Searching inside a table (help, probably INDEX, and MATCH)

[cpis0002]

Hi, I have a worksheet with the following data in column A5 down:

SR1
SR2
SR3
SR4
CS1
CS2
CS3
CS4
GP1
GP2
GP3
GP4

and row 3 with data 11, 12, 13, ..., 79

Then on another sheet on cells B4 and B5, you insert row code and column code respectively... so in cell B4 I would enter CS4 (example), and in cell B5 I would enter 17 (example)... I need a formula to look at cells B4 and B5 and find the data in the large table described above... any help would be useful

 

[Aladin Akyurek]

=VLOOKUP(B4,Sheet1!$A$4:$K$400,MATCH(B5,Sheet1!$A$3:$K$3,1),0)

 

[njimack]

Assuming your headers in row 3 start from B3, the following formula should suffice:

=INDEX(Sheet1!B5:BR16,MATCH(B4,Sheet1!A5:A16,0),MATCH(B5,Sheet1!B3:BR3,0))