Hi All,
I am disappointed I cannot work this out myself
I want to lookup a specific Test String in a pivot table and once matched get the corresponding TOTAL.
Example. I want to find RENT'S grand total in the table below.
<tbody>
</tbody>
This CELL is in another worksheet but I can work the referencing out myself I think. Just need the basic formula.
I was trying something along the lines of vlookup("RENT", and then using RIGHT but I cannot get it to work.
Thank you
I am disappointed I cannot work this out myself
I want to lookup a specific Test String in a pivot table and once matched get the corresponding TOTAL.
Example. I want to find RENT'S grand total in the table below.
YEAR | JAN | FEB | MAR | APR | MAY | JUN | JULY | AUG | SEPT | OCT | NOV | DEC | TOTAL |
FUEL | |||||||||||||
RENT | £100 | ||||||||||||
SHOPPING | |||||||||||||
MOBILE |
<tbody>
</tbody>
This CELL is in another worksheet but I can work the referencing out myself I think. Just need the basic formula.
I was trying something along the lines of vlookup("RENT", and then using RIGHT but I cannot get it to work.
Thank you
Last edited: