I am trying to create a formula or something that will go from a value
in sheet and go to sheet 2 and find it in column A. Depending on where
it is in column A, then choose the value that is in the column in B and
multiply it by that value.
..............
Ex:
Sheet 1: (M11) contains the value 2
Sheet 2: contains a list of levels in column A that range from 1 - 30
Sheet 2: Columns B - D contain the cost of each item depending on level
in Column A.
Sheet 1: (M12) will go and verify number entered into (M11) and find
the value for level and cost of column B, then mulitly it by the value
that you enterin M12.

I know I may be explaining it badly but just need something to go
through the table or listing find the value of the level I entered in
another cell, find the cost associated for that level, and multiply it
by the number that I enter in the cell.




0 30 240 600
1 30 240 600
2 30 240 600
3 30 240 600
4 29 232 580
5 29 232 580
6 29 232 580
7 28 224 560
8 28 224 560
9 28 224 560
10 27 216 540
11 27 216 540
12 27 216 540
13 27 216 540
14 26 208 520
15 26 208 520
16 26 208 520
17 25 200 500
18 25 200 500
19 25 200 500
20 24 192 480
21 24 192 480
22 24 192 480
23 24 192 480
24 23 184 460
25 23 184 460
26 23 184 460
27 22 176 440


--
mauddib13
------------------------------------------------------------------------
mauddib13's Profile: http://www.excelforum.com/member.php...o&userid=25785
View this thread: http://www.excelforum.com/showthread...hreadid=522039