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