Hello
Not getting what you need exactly...
As far I have understood you need to lookup for the current week number and get the corresponding value...
This may help
=VLOOKUP(WEEKNUM(TODAY()),A:B,2,FALSE)
Sorry if this is not what you need...
Hello
Not getting what you need exactly...
As far I have understood you need to lookup for the current week number and get the corresponding value...
This may help
=VLOOKUP(WEEKNUM(TODAY()),A:B,2,FALSE)
Sorry if this is not what you need...
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks