I thought this would be simple however, I am finding more difficult than I originally thought. I'll try and keep it simple.
I have a single workbook with multiple sheets with data. I am needing a formula to check column A on sheet #1 to columns A,B, and C on sheets #2 and #3 . If the numbers found in column A of sheet #1 match the other sheets then display TRUE if not FALSE.
My issue is dealing with the different sheets in the same formula. Here is a formula I made that works but doesn't deal with the multiple sheets.
ISNUMBER(Match(A2,'WB#2 '!$A$2:$A$10,0))
A2 needs to look at WB#2 and WB#3 (same columns) and look for the same value of A2 on WB#1 . If any matches display TRUE if not FALSE.
Please assist if possible...if you need more information please let me know. I can't seem to figure it out.
I have a single workbook with multiple sheets with data. I am needing a formula to check column A on sheet #1 to columns A,B, and C on sheets #2 and #3 . If the numbers found in column A of sheet #1 match the other sheets then display TRUE if not FALSE.
My issue is dealing with the different sheets in the same formula. Here is a formula I made that works but doesn't deal with the multiple sheets.
ISNUMBER(Match(A2,'WB#2 '!$A$2:$A$10,0))
A2 needs to look at WB#2 and WB#3 (same columns) and look for the same value of A2 on WB#1 . If any matches display TRUE if not FALSE.
Please assist if possible...if you need more information please let me know. I can't seem to figure it out.
