Data Address - Row No.
 

Hi,

In Sheet 1, I have this Data,
Column 1
Row 1 Data 1
Row 2
Row 3 Data 2
Row 4
Row 5
Row 6
Row 7 Data 3
Row 8 Data 4
Row 9 Data 5
Row 10
Row 11 Data 6

In Sheet 2
Column 1 Result
Row 1 Data 1 1
Row 2 Data 2 3
Row 3 Data 3 7
Row 4 Data 4 8
Row 5 Data 5 9
Row 6 Data 6 6

My aim is to get the Row Number in Sheet 1 if the Data in Sheet 2 is
matching with Sheet 1. Let say, if I type "Data 1" in cell A1 the result in
B1 should be "1". If Data 2, result must be "3", and soon.

Thanks for the help.

EricBB

Data Address - Row No.
 

What you need is the Match function:

=MATCH(A1,Sheet1!A:A,FALSE)

hth

Carlo

On Nov 27, 3:55 pm, EricBB wrote:
Hi,

In Sheet 1, I have this Data,
Column 1
Row 1 Data 1
Row 2
Row 3 Data 2
Row 4
Row 5
Row 6
Row 7 Data 3
Row 8 Data 4
Row 9 Data 5
Row 10
Row 11 Data 6

In Sheet 2
Column 1 Result
Row 1 Data 1 1
Row 2 Data 2 3
Row 3 Data 3 7
Row 4 Data 4 8
Row 5 Data 5 9
Row 6 Data 6 6

My aim is to get the Row Number in Sheet 1 if the Data in Sheet 2 is
matching with Sheet 1. Let say, if I type "Data 1" in cell A1 the result in
B1 should be "1". If Data 2, result must be "3", and soon.

Thanks for the help.

EricBB

Data Address - Row No.
 

What you need is the Match function:

=MATCH(A1,Sheet1!A:A,FALSE)

And if you want to ignore empty cells:

=if(A1="","",MATCH(A1,Sheet1!A:A,FALSE))

And for ignoring errors:

=IF(A1="","",IF(ISERROR(MATCH(A1,Sheet1!A:A,FALSE) ),"not
found",MATCH(A1,Sheet1!A:A,FALSE)))


hth


Carlo

Data Address - Row No.
 

hi carlo,
this is really what i want. thank you so much
EricBB

"carlo" wrote:

What you need is the Match function:

=MATCH(A1,Sheet1!A:A,FALSE)

And if you want to ignore empty cells:

=if(A1="","",MATCH(A1,Sheet1!A:A,FALSE))

And for ignoring errors:

=IF(A1="","",IF(ISERROR(MATCH(A1,Sheet1!A:A,FALSE) ),"not
found",MATCH(A1,Sheet1!A:A,FALSE)))


hth


Carlo

Data Address - Row No.
 

On Nov 27, 5:00 pm, EricBB wrote:
hi carlo,
this is really what i want. thank you so much
EricBB



"carlo" wrote:
What you need is the Match function:

=MATCH(A1,Sheet1!A:A,FALSE)

And if you want to ignore empty cells:

=if(A1="","",MATCH(A1,Sheet1!A:A,FALSE))

And for ignoring errors:

=IF(A1="","",IF(ISERROR(MATCH(A1,Sheet1!A:A,FALSE) ),"not
found",MATCH(A1,Sheet1!A:A,FALSE)))

hth

Carlo- Hide quoted text -

- Show quoted text -

you're welcome!