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
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 …