Forum Discussion
Search matching values across sheets and return a range of data from sheet matching value found on
Hello, I am trying to do the below: If value A1 on Sheet 1 matches any C3 values on Sheet 2 through Sheet 5 then return all values from range D3:G6 from the sheet with the matching C3 value t...
If you have access to VSTACK, perhaps...
=LET(stack, VSTACK(Sheet2:Sheet5!C3:G3), DtoG, DROP(stack, , 1), c, TAKE(stack, , 1), FILTER(DtoG, c = A1))