Calc: Reference data from another sheet based on criteria met

asked 2020-02-26 22:30:33 +0200

katkun gravatar image

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: http://shrani.si/f/x/V6/4ZuYxMR/a.jpg http://shrani.si/f/1m/11a/3QDo0b2R/b.jpg

edit retag flag offensive close merge delete