I am trying to escalate values based on an index from another worksheet. The other worksheet is called "X". Currently, my formula is as follows:
This code is part of a loop and works perfectly. It is linking the cells I want to the cells in the "Money In" workbook. My issue is figuring out how to multiply each of these values by a factor that is indexed from worksheet "X". The key in worksheet "X" is in the range B10:B20 and the factors I want to pull in and multiply by are in E10:E20. How would I go about doing this?
Bookmarks