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

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

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

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

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!