I’ve seen similar questions and answers, but I can’t make it work properly…
I’ve data on the sheet “back_up” in columns from A to J starting in row 7.
In column A I have several categories like: top, middle, bottom.
I could filter data based on column A, but I also want to copy filtered data to separate sheet (without column A).
So the question is how can I do the following:
In sheet “data_top” I would like in columns A to I copied data from sheet “back_up” from rows that have in column A (back_up) written “top”. I think there needs to be a combination of If and VLOOKUP function, but I don’t know how to properly build the function.
Visual presentation: