Forum Discussion
Solved
Merging tables together
Hi everyone, I am wanting one table to read from another. Table 1 J4 which is highlighted I would like to have a "1" in it if they have a 1 in any of the columns in j55-n55 ( the top colum...
=IF(SUM(N(ISNUMBER(SEARCH(1,J55:N55)))),1,IF(SUM(N(ISNUMBER(SEARCH(0,J55:N55)))),0,""))You can try this formula. This works in my sample file if both tables are on the same sheet.
=IF(SUM(N(ISNUMBER(SEARCH(1,'table 2'!J55:N55)))),1,IF(SUM(N(ISNUMBER(SEARCH(0,'table 2'!J55:N55)))),0,""))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
The tables are on the same sheet, would that effect the formula?
=IF(SUM(N(ISNUMBER(SEARCH(1,J55:N55)))),1,IF(SUM(N(ISNUMBER(SEARCH(0,J55:N55)))),0,""))You can try this formula. This works in my sample file if both tables are on the same sheet.
- Thank you