Pulling a value from a cell given a value of category and half year and inserting into a function

Summary

Pulling a value from a cell given a value of category and half year and inserting into a function

Content

I need to amend a value pulled from EPM via SmartView, these values have some post processing by pulling a value from a cell given a value of category and half year and inserting into a function.

I have looked at reference variables but I can't see how to pull a value from  the matching category/half year in the lookup to the equivalent cell in the report to create a function to enable the post processing, the examples only seem to reference hard coded cells