How to return a row reference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NHRunner - 10 Jul 2006 21:02 GMT

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.

Reply to this Message

Niek Otten - 10 Jul 2006 21:07 GMT

Look at the MATCH() function

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a formula which needs a row reference. The row reference needs to be
| the result of search.
[quoted text clipped - 3 lines]
| I need to search the column to find an exact match on a supplied date and
| return the ROW reference not the date value.

Reply to this Message

NHRunner - 10 Jul 2006 21:20 GMT

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

> Look at the MATCH() function
>
[quoted text clipped - 7 lines]
> and
> | return the ROW reference not the date value.

Reply to this Message