third macro. lets make it that macro will search keywords highlighted in orange on sheet 1, search in fields highlighted also in orange on sheet 2, and input results in the FIRST empty column on sheet 2 with column heading of "search results".
multiple findings should be separated by /.