Bump - No replies yet... :-(

I have a spreadsheet that I need to do some miracle math for me.
There are three sheets in the workbook.
Sheet 1 is a dump from a web report. I can’t change the way it is laid out.
Sheet 2 and 3 are just explanations and billing values. I can move these all I want.

Here is what I need it to do:
Take the service in sheet 1 column C and determine the value found on the other sheet. For instance, Array...