Range of Values with different column selection

[CharlieR]

I have arranged columns of data. In the first two columns I have chosen the
item to do and the supplier of the service. I need to add a value for the
service relative to the selection of the provider. My data sits in further
columns to the right each column according to the individual supplier who is
listed across the top row. I can arrange to select the supplier but am
getting lost in sorting the data ie cost per supplier.

 

[Pecoflyer]

I have arranged columns of data. In the first two columns I have chosen
the
item to do and the supplier of the service. I need to add a value for
the
service relative to the selection of the provider. My data sits in
further
columns to the right each column according to the individual supplier
who is
listed across the top row. I can arrange to select the supplier but am
getting lost in sorting the data ie cost per supplier.

*How to get further help with a workbook*
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join *you will have the
opportunity to add attachmnets to your posts* so you can add workbooks
to better illustrate your problems and get help directly with them. Also
if you do join please post in this thread (link found below) so that
people who have been following or helping with this query can continue
to do so.