I want to use GETPIVOTDATA to pick from a table in which the first column is
a state designator and is not repeated in every record - is this feasible?
I will use the state designator and a code (from the second column of the
Pivot table) to give me the correct premium rate to be applied using MATCH
and INDEX

But I'm striking out on getting the state in any row other than the one it
shows up in ...

My brainbox is fired on this
.....
--
Dai Evans
Laguna Beach, CA