I've asked a similar question already but didn't get a workable resolution so
thought I'd ask again.

I've entered the following formula into one worksheet, referencing a pivot
table in another worksheet (using the getpivotdata function):

=GETPIVOTDATA('USE THIS! - PIVOT TABLE'!A5,"1240 A TOTAL")

This works fine, pulling out the correct figure from the table, but rather
than entering a specific client, via the '1240' (which is a client ref), I'd
like to cross reference a cell in column A (on the same row) in a sort of
vlookup function - the client refs may change as this is a worksheet that is
updated regularly.

Any ideas?