Hi,
I am attempting to search the values of Column A on the "data" sheet and return the values from Column A and G Onwards onto Sheet2.
I have the search function somewhat working as it is returning values that contain the inputted search parameter of Column A but seems to be duplicating when it find the search parameter in another column also.
Would really appreciate some help to get me the search results I am looking for.