Find, Match and Populate Formula

Im done with adjusted the ranges to 1000 rows, and follow this when you copy paste the formula:

1. Double click on formula first row, or press F2 button keyboard, so you can see formula inside cell
2. and then select it or blocked it wirh your mouse, from left to right formula, and copy that formula with your right click mouse or you can press CTRL-C)
3. and paste on desired workbook on desired cell, yes you must open you actual workbook first
4. Last step when you see the error, double click again or F2, when formula or cell contain formula open, press CTRL-SHIFT-ENTER button together (coz this array formula)

Thanks