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