Find text in array & return adjacent cell value

[econbizer]

Dear all, I'm pretty muddled with this & would appreciate your help!

I'm looking for a cell reference solution to finding any "text/number" in a given array & returning an adjacent cell value.
The adjacent cell being called should be dynamic.. could be (3 rows down, 1 right) or even (5 rows down, 6 right).

For eg, cell B2 will contain the formula, to find the text "Syllabus e01932 summer" in my given array & then returning its adjacent cell value, "26" (3 rows down, 1 column right).

Please see the attached screen shot/workbook!
I wish to solve this using cell formulas & not vba macros.


Thank you,
eb

Find text in array return adjacent cell value.JPG
Find text in array return adjacent cell value.xls