Thanks i hadnt considered the Match Function before so ill try that, although
it is new to me.
And yes the column headers of the graph read
.....a..............b.....c......d... etc
1.................429, 430, 431 etc
2.Group 1.....10...
3.Group 2.....20...
4.Group 3.....30...

etc


"Paul Lautman" wrote:

How do you know that the 430 column is the 430 column? Is there a header row
with the value 430 in a cell in that row?
If so, you could use the MATCH function to identify the column offset and
then the various paste or assignment operators to populate the column.