G
ganga
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.
as in either sheet 1,2 or 3 give me the sheet name.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Ms-Exl-Learner
Can you please explain, in which Particular Columns the Number will be
available in sheet1, sheet2 & sheet3 and give some examples of the numbers.
available in sheet1, sheet2 & sheet3 and give some examples of the numbers.
G
ganga
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.
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
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
=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