I'm looking for a Macro or Function that will look for a match Column A 1:200 to Column A 220:500 and on a match insert the variance into Column B 520:800 that corresponds to the matched name. I've attached a small sample file. Find match for Column A220:A500 from A1:A200 and calculate the variance for the remaining columns and add to corresponding name in A:520:800.
Thank You!!!
Bookmarks