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...
In B1:
=IFS('Sheet 2'!C3=A1, 'Sheet 2'!D3:G6, 'Sheet 3'!C3=A1, 'Sheet 3'!D3:G6, 'Sheet 4'!C3=A1, 'Sheet 4'!D3:G6, 'Sheet 5'!C3=A1, 'Sheet 5'!D3:G6, TRUE, "")
Replace the sheet names with the actual names (if necessary).