How to return a row reference

[NHRunner]

I have a formula which needs a row reference. The row reference needs to be
the result of search.

The search is on a series of ascending dates in a column.

I need to search the column to find an exact match on a supplied date and
return the ROW reference not the date value.

[Niek Otten]

Look at the MATCH() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"NHRunner" <[email protected]> wrote in message news:[email protected]...
|I have a formula which needs a row reference. The row reference needs to be
| the result of search.
|
| The search is on a series of ascending dates in a column.
|
| I need to search the column to find an exact match on a supplied date and
| return the ROW reference not the date value.
|
|
|
|

[NHRunner]

I tried that but it only returned the row relative to the start of the
range.
I just realized that since I'm searching for an exact match I can always
start the range at row one and I get the actual row in the sheet which is
what I need.

Thanks for triggering the thought process.

Steve



"Niek Otten" <[email protected]> wrote in message
news:[email protected]...
> Look at the MATCH() function
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "NHRunner" <[email protected]> wrote in message
> news:[email protected]...
> |I have a formula which needs a row reference. The row reference needs to
> be
> | the result of search.
> |
> | The search is on a series of ascending dates in a column.
> |
> | I need to search the column to find an exact match on a supplied date
> and
> | return the ROW reference not the date value.
> |
> |
> |
> |
>
>