I have a table (A to M) which shows a list of "Impact Factors" which have scores attributed to them plotted across a year. These scores are changed based on actions taken according to the target month (column Q) and should reduce to the new score from that month onwards in the A to M table. The actions table (P to R) is taken from another list using FILTER. My original formula looks up the month/year and the Impact Factor to the actions table and if necessary changes the score in the table... however, i didnt consider a secondary Impact Factor in the actions table and my vlookup formula only captures the first (in my example, Impact F should reduce to 1 from 10 2025).
I've started to see if I can COUNTIF number of times an Impact Factor shows in column P and if its more than 1 then to look up somewhere else.. but im then finding myself back where i started with not being able to lookup the second occurence. Basically i'm a bit muddled! Am I on the right track, or is there a better way to do this?
I've started to see if I can COUNTIF number of times an Impact Factor shows in column P and if its more than 1 then to look up somewhere else.. but im then finding myself back where i started with not being able to lookup the second occurence. Basically i'm a bit muddled! Am I on the right track, or is there a better way to do this?
