Formula calculating in a moving cell

I have a sheet that has a Pivot table and a column with formulas, referencing cells in the pivot table.
The problem is that the pivot table changes size and shape, depending on what values are filtered. When the pivot table changes all the formulas become invalid, since they are referencing a now empty cell.

How can I make it that the formulas follow the cells?

you can add IFNA(current formula,"") to each cell and this will change to blank once filtered

Nah, I need the formula to follow the cells and calculate based on their values.

If you post an example workbook I can take a look

In that case you should be able to use a lookup to search for the return you are looking for.

Going to need a sample workbook detailing what you're trying to achieve and I'll take a look

Thank you, PFDave and Glenn Kennedy!

My situation is exactly the one Glenn Kennedy has described.
I should have been more clear, I thought my matter simple enough to not need an example workbook.

I know about the GETPIVOT function and it works, but I was wondering if there was another way - I thought for sure Excel would have a function that followed a cell, somewhat. So say I have that exact same pivot table and want my formula to follow the cells, without using the GETPIVOT function - is it possible?

Originally Posted by Glenn Kennedy

Regarding simplicity... A picture is worth 1000 words and a sample spreadsheet 1000 x 1000 words...

*giggidy*

I'll just use the GETPIVOT function. It will work, as long as the chosen data isn't filtered out, right?