LinkBack URL
About LinkBacks
cpmsimoes 
Hello,
Need your help! I'm stuck!
Is there any way to return a string looked between two dates?
I attach one Excel file with the resut I pretend.
Thanks for your help.
Regards
Hello,
Need your help! I'm stuck!
Is there any way to return a string looked between two dates?
I attach one Excel file with the resut I pretend.
Thanks for your help.
Regards
Hi,
there are for sure better solutions
=INDEX($C$2:$C$4,MATCH(1,INDEX(1/($B$2:$B$4>=G2),0),0))
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Try this.....
The formula given below is an array formula, so it needs to be confirmed with Ctrl+Shift+Enter and then copy down
H2 =INDEX($C$2:$C$4,MIN(IF($B$2:$B$4>=G2,ROW($B$2:$B$4)-ROW($B$2)+1)))
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
=vlookup(g2,$a$2:$c$4;3,true)
Thank you all!
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks