On Feb 29, 10:33*am, Pete_UK wrote:
Use MATCH( ). It will return the (relative) row of where the matching
item is located.

Hope this helps.

Pete

On Feb 29, 5:27*pm, William G wrote:



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- Hide quoted text -

- Show quoted text -

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