Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Form return lookup values
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Bob Phillips, post: 6373960"] Is this array forula what you want? =INDEX(A1:C10,MATCH(TODAY(),INDEX(A1:C10,0,MIN(IF(A1:C1=startdate,COLUMN(A1:C1)))),1)+1,MATCH(startdate,A1:C1,0)) [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Form return lookup values
Top
