How to return a row reference

N

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.
 
N

Niek Otten

Look at the MATCH() function

--
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.
|
| 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.
|
|
|
|
 
N

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
 
Top