match numbers
 

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.

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

--------------------
(MS-Exl-Learner)
--------------------



"ganga" wrote:

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.

match numbers
 

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.


"Ms-Exl-Learner" wrote:

Can you please explain, in which Particular Columns the Number will be
available in sheet1, sheet2 & sheet3 and give some examples of the numbers.

--------------------
(MS-Exl-Learner)
--------------------



"ganga" wrote:

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.

match numbers
 

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

On Sep 14, 5:49*pm, ganga wrote:
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.



"Ms-Exl-Learner" wrote:
Can you please explain, in which Particular Columns the Number will be
available in sheet1, sheet2 & sheet3 and give some examples of the numbers.

--------------------
(MS-Exl-Learner)
--------------------

"ganga" wrote:

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.- Hide quoted text -

- Show quoted text -