![]() |
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 |
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 |
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 |
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