- I have this formula =IFNA(VLOOKUP($D$3,'Market CUME'!A:AD,2,FALSE),"") sitting in cell Q3. It looks for the D3 value in the Market CUME tab and populates Q3.
- D3 is populated by people using a drop down menu, selecting from 89 options pulling from a list in J2:J89.
- K2:K89 is populated with a number, actually a percent. This percent is associated with the corresponding value in column J. I’m trying to connect the dots between the corresponding values in J and K.
I need a formula in R3 that will multiply the results of the first formula by the value in the corresponding K2:K89 cell, in this case K42 because D3 = Knoxville. Lets say the value in K42 = 20% So if the D3 issue wasn’t in play the formula I am looking for would include =Q3+(Q3*K42) The resulting number would be 267476
Confused enough? Thanks in advance for the help.