Hi, I'm trying to create a macros(or excel function) that gives me column K. Please see the attached file. I would like to compare 1st value in column I(changes for every company name) to column G(date1) and return values in column F(count factor) corresponding to it in Column K. So, for eg. for bananas, I should get 20 in column K since its value in column G matches (or is approximately equal to) 9/9/15.

Kindly help! Thanks!

PS: I'm trying to use this formula- =INDEX(F2:F3541,MATCH(I2,G2:G3541,-1)) But it doesnt seem to work. Also, I2 isnt a fixed value- so this formula doesnt take that into account. Perhaps a macro might be more helpful to solve this.

Looking forward to your expert advice Thanks in advanceEdited Column Match.xlsx