How to search filter by column between sheets in Calc

asked 2020-06-16 17:49:23 +0100

BernieSorbet gravatar image

updated 2020-08-18 13:21:01 +0100

Alex Kemp gravatar image

Basically I have 4 sheets, source, 1, 2 and 3. I want to use Source's column C and search for its entries in column C of sheets 1, 2, and 3. With those filtered, copy the entries of Column B in those 3 sheets and paste them respectively on the Source sheet

edit retag flag offensive close merge delete


if it's possible to put the 'key-col.' C before the 'value-col.' B in sheets 1,2,3 vlookup could be a friend ...

newbie-02 gravatar imagenewbie-02 ( 2020-06-20 19:17:35 +0100 )edit