Hi all... having some trouble getting this to work the way I'd like. Please refer to the worksheet image... it's the best way for me to explain what I'm trying to do.
I want to look at the first three characters in the Indicator column (column A), look at the appropriate table that matches that value in columns F and G, grab the correct dollar amount in that table from column G based on the number of units in column B that corresponds to the number in column F, and then multiply B and F in column C. I've included the expected results for rows 2-9 in columns J and K. This would be done over thousands of rows and will be repeated several times with different variations, so I only want to do this once and just be able to copy the formula all the way down column C. Any help is greatly appreciated!
I want to look at the first three characters in the Indicator column (column A), look at the appropriate table that matches that value in columns F and G, grab the correct dollar amount in that table from column G based on the number of units in column B that corresponds to the number in column F, and then multiply B and F in column C. I've included the expected results for rows 2-9 in columns J and K. This would be done over thousands of rows and will be repeated several times with different variations, so I only want to do this once and just be able to copy the formula all the way down column C. Any help is greatly appreciated!