Vlookup or match?

[vxs]

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.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]YEAR[/TD]
[TD]JAN[/TD]
[TD]FEB[/TD]
[TD]MAR[/TD]
[TD]APR[/TD]
[TD]MAY[/TD]
[TD]JUN[/TD]
[TD]JULY[/TD]
[TD]AUG[/TD]
[TD]SEPT[/TD]
[TD]OCT[/TD]
[TD]NOV[/TD]
[TD]DEC[/TD]
[TD]TOTAL[/TD]
[/TR]
[TR]
[TD]FUEL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RENT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]£100[/TD]
[/TR]
[TR]
[TD]SHOPPING[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MOBILE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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

 

[vxs]

I was one column short for the second MATCH.

This will do it:

=INDEX(A2:N6,MATCH("RENT",A2:A6,0),MATCH("Total",A2:N2,0))

Thank you all that replied.

The quoted post above did the trick and I was able to update the cell references to the different sheets required.

Thanks for taking the time to help all