Data Address - Row No.

[EricBB]

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

 

[carlo]

What you need is the Match function:

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

hth

Carlo

 

[carlo]

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

 

[EricBB]

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

 

[carlo]

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





- Show quoted text -

you're welcome!