#### jo.stanley

##### Board Regular

- Joined
- Apr 13, 2004

- Messages
- 177

I have a spreadsheet that on one sheet has a matrix

e.g. (a) 2 months free + (b) 3 = (c) 15122

(a) Best of Deal + (b) 4 = (c) 17822

To explain the information above the (a) is text which describes a deal (b) is just a number that can be from 1 to 11 for any deal (c) is a unique figure that is based on the criteria of (a) and (b).

I also have a second sheet that only shows (a) and (b) and I need to write a formula that takes the information from the above matrix and adds (c) to this second sheet.

I have no idea where to start and I wonder if someone can assist in any way.