G ganga Sep 14, 2009 #1 i have numbers in 3 different sheets and on sheet 4 if have the same number as in either sheet 1,2 or 3 give me the sheet name.
i have numbers in 3 different sheets and on sheet 4 if have the same number as in either sheet 1,2 or 3 give me the sheet name.
M Ms-Exl-Learner Sep 14, 2009 #2 Can you please explain, in which Particular Columns the Number will be available in sheet1, sheet2 & sheet3 and give some examples of the numbers.
Can you please explain, in which Particular Columns the Number will be available in sheet1, sheet2 & sheet3 and give some examples of the numbers.
G ganga Sep 14, 2009 #3 sure.. sheet 1 sheet 2 sheet 3 sheet 4 in A row in A row in A row in A row in B row 1 10 9 14 sheet 2 12 14 100 2 13 33 3 6 4 5 all the numbers in the sheets are already there but i only want to get the info in sheet 4 row b.
sure.. sheet 1 sheet 2 sheet 3 sheet 4 in A row in A row in A row in A row in B row 1 10 9 14 sheet 2 12 14 100 2 13 33 3 6 4 5 all the numbers in the sheets are already there but i only want to get the info in sheet 4 row b.
P Pete_UK Sep 14, 2009 #4 Put this in B1 of Sheet4: =IF(ISNA(MATCH(A1,Sheet1!A:A,0)),"","Sheet1") & IF(ISNA(MATCH (A1,Sheet2!A:A,0)),"","Sheet2") & IF(ISNA(MATCH(A1,Sheet3!A:A, 0)),"","Sheet3") By the way, A and B refer to columns - rows are numbered 1, 2, 3, 4 etc. Hope this helps. Pete
Put this in B1 of Sheet4: =IF(ISNA(MATCH(A1,Sheet1!A:A,0)),"","Sheet1") & IF(ISNA(MATCH (A1,Sheet2!A:A,0)),"","Sheet2") & IF(ISNA(MATCH(A1,Sheet3!A:A, 0)),"","Sheet3") By the way, A and B refer to columns - rows are numbered 1, 2, 3, 4 etc. Hope this helps. Pete
