offset/compound lookup formula wanted

[richnorm]

I need help to write a formula which finds text in an array and returns the numerical value a given number of rows and columns away. The text only appears once in the array. The offset needs to be variable. Hope someone out there can help!
cheers
Richard

[mikerickson]

It would help if a description of your data layout was accompanied by an example file.

[richnorm]

Example file added. Hope this helps.
cheers
Richard

[Bjornar]

Let me know if this formula gives you the result you are looking for.

In G5, and copied to the other output cells

Please Login or Register  to view this content.

See attachment

[richnorm]

Many thanks for that Bjornar. Saved me a deal of grief!
cheers
Richard