PivotTable Formula

[PipBoy808]

Hello,

I have a pivot table that is two columns wide. The main headings in Column A have all been expanded to show those in column B and presented in tabular form. Can anyone tell me a formula that will return the values in the column C? I've been messing around with GetPivotData but can't get it quite right, although I could be on the wrong track entirely.

Thanks in advance!

A B C
+Colour -Red Colour
-Blue Colour
-Green Colour (is there a formula for this?)


Thanks!

Edit: Oh man, no amount of editing is making my illustration look any better. I hope that my initial explanation is enough for people to understand what I'm talking about

Edit 2: I've attached a file. Imagine it's a pivot table

 

[H_Milli]

See Attachment. I created a vlookup formula combined with an IfError that should do the trick.

 

[NARAYANK991]

Hi ,

See the file for an alternative.

Narayan