Help with dynamic formula including OFFSET and VLOOKUPs

Hi All,

I would be very grateful if you could help me with the attached spreadsheet.

I need to be able to show the 'Sub Total' values in the 'Snapshot Tab' in $ equivalent. For example, columns D and E in the Snapshot tab have $,€ and £ values extracted from the Status Report tab, so I need the $ value in each case when it's in € or £ at the exchange rate in column T in order to sum up the Sub Total only in dollars.

The 'Sub Total' cell is not static as this moves up or down according to what happens in the 'Status Report' tab (as you can see in the formulas). Each of the cells in these columns are not static either and could change currency as well.

The objective is to always have the SubTotal value in the dollar equivalent as this moves and changes according to the 'Status Report' tab.

Help is much appreciated.

Thanks a lot,