I have an array. and want to search a specific column for a value greater than 0 in the array. if i find a value greater than 0 i want to return the text entered in a different column of the array. See below for a picture.
i want to search column labeled 1 and any cell with a value greater then 0 will then return the text from the cell next to in from the column titled "category"
for example i search Column labeled 1 and find cell with "3" in it. cell with Adhesive Issues will be copied and returned to another cell. Also column with a 1 will return "did not cool" etc.
There is a similar case that based on a selected row header (yours is column header) to get the list of data in a row (yours is column), and then return the column headers of the data (yours is to return row header).