Hi all,
I have a table set as # of users down 1 column (users 1-5), and # of PCs across 3 rows (PCs 0, 1, 2). A support price is set at the intersection of the # of users and the # of PCs.
For example, the table may look like this:
0 1 2
1 $100 $200 $300
2 $100 $300 $400
3 $100 $400 $500
4 $100 $500 $600
5 $100 $600 $700
I need a formula that will read down the first column to the correct # of users (as specified in another cell), and then across to the correct # of PCs (again, as specified in another cell).
I believe I would be using OFFSET and MATCH for this but cannot get the syntax/logic for it right.
This message was edited by Rylandir on 2002-09-12 11:56
I have a table set as # of users down 1 column (users 1-5), and # of PCs across 3 rows (PCs 0, 1, 2). A support price is set at the intersection of the # of users and the # of PCs.
For example, the table may look like this:
0 1 2
1 $100 $200 $300
2 $100 $300 $400
3 $100 $400 $500
4 $100 $500 $600
5 $100 $600 $700
I need a formula that will read down the first column to the correct # of users (as specified in another cell), and then across to the correct # of PCs (again, as specified in another cell).
I believe I would be using OFFSET and MATCH for this but cannot get the syntax/logic for it right.
This message was edited by Rylandir on 2002-09-12 11:56