Basic table lookup

[mys Scott]

I'm sure this question is in the forums somewhere (I did look) already so please feel free to direct me to an existing thread if you want.
I have an all text table (i.e. no math req'd). Rows are task numbers (1 through 100) and columns are job names. On a different worksheet I need to return the text string in a cell in this table based on its column name and row name. Below is a link to a google doc showing similar 2 work sheets

https://docs.google.com/spreadsheet/...NQWUE&hl=en_US

Also, attached to this message is the same workbook in Excel.

So on worksheet "Lookup Sheet" I need to be able to enter the job name and the task number and have the task brief returned. The target cell is C2 (to enter the formula to return the "value" based on the row and column criteria).

Pretty simple I think, just need to pointed in the right direction.
With Thanks,
Scott

[ChemistB]

Use Index and Match functions like so

=INDEX('Data Table'!$B$2:$E$11,MATCH(B2,'Data Table'!$A$2:$A$11,0),MATCH(A2,'Data Table'!$B$1:$E$1,0))

Is that what you were looking for?

[Richard Buttrey]

Hi,

Does the attached help?

Regards