I have a Index/Search Function placed on Col G which returns closest fit data (can be single or many). The Index/Search Function reads item on Cell E2.

1. Using human judgement, i will select the appropriate cell which is best fit (G6)
2. Copy it
3.Position cursor on the Col cell adjacent to one shown in Formula Bar (B46)
4.Paste Special Text

Anyone care to share Macro VBA codeto automate Steps 2 to 4 ?

copy_paste.png