| test.xls | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |||
| 1 | CatID# | ELECTMTCHours | Inv.Material$ | Mutiplier | 09645 | 09655 | 09656 | 09751 | 09752 | 09757 | 09889 | 10236 | 10673 | 10675 | 10676 | 10842 | 10877 | ||||
| 2 | 10842 | 9655 | #N/A | 1.5 | 81 | 3 | 3 | 10 | 3 | 1 | 7 | 20 | 6 | 3 | 6 | 5 | 5 | 7 | 3 | ||
| 3 | 9645 | 9655 | #N/A | 1 | 40 | 2 | 3 | 10 | 3 | 1 | 7 | 20 | 6 | 3 | 6 | 5 | 5 | 7 | 3 | ||
Buchanan Survey | |||||||||||||||||||||
This is a partial of the sheet that I am working on.
The current Formula in Column L is manually entered for each line. What I would like to know is if there is a way to have a macro that would create this formula?
What we would need it to do is check out the Cat ID #'s in cells H - J and based upon the numbers in there, look up the $ amount (right now they are in columns N-Z). The amount in column M would be manually input and then the formula in column L would be
the value in M multiplied by the sum of the values that correspond with the ID #'s in H-J plus 10.
Is this possible?
Thanks,
TNEMOM
