jo.stanley
Board Regular
- Joined
- Apr 13, 2004
- Messages
- 177
I hope I can explain this so it makes sense!
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.
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.