Formula to return the row count of a value in Vlookup

[William G]

I'm trying to return the number of rows in the vlookup formula as the
count will change monthly.

I'm looking to have the value 2/29/08 return a 2 under the following
formula

=vlookup(2/29/08,a1:a3,?,false)


1/31/08
2/29/08
3/31/08

Next month it will need to reference 3/31/08.

What formula is needed in place of the '?' in the above formula?

Thank you for your help.
William

 

[Pete_UK]

Use MATCH( ). It will return the (relative) row of where the matching
item is located.

Hope this helps.

Pete

 

[William G]

Use MATCH( ). It will return the (relative) row of where the matching
item is located.

Hope this helps.

Pete






- Show quoted text -

Thank you...that worked PERFECT!!!!!
William

 

[Pete_UK]

Well, that was quick !!

Glad to be of help, and thanks for feeding back.

Pete