ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula to return the row count of a value in Vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/178325-formula-return-row-count-value-vlookup.html)

William G

Formula to return the row count of a value in Vlookup
 
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

Formula to return the row count of a value in Vlookup
 
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



William G

Formula to return the row count of a value in Vlookup
 
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

Pete_UK

Formula to return the row count of a value in Vlookup
 
Well, that was quick !!

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

Pete

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

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



All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com