Data Address - Row No.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EricBB - 27 Nov 2007 06:55 GMT

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

Reply to this Message

carlo - 27 Nov 2007 07:16 GMT

What you need is the Match function:

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

hth

Carlo

> Hi,
>
[quoted text clipped - 28 lines]
>
> EricBB

Reply to this Message

carlo - 27 Nov 2007 07:19 GMT

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

Reply to this Message

EricBB - 27 Nov 2007 08:00 GMT

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

> What you need is the Match function:
>
[quoted text clipped - 12 lines]
>
> Carlo

Reply to this Message

carlo - 27 Nov 2007 08:14 GMT

> hi carlo,
> this is really what i want. thank you so much
[quoted text clipped - 18 lines]
>
> - Show quoted text -

you're welcome!

Reply to this Message