The macro above gives this result. I am not sure how it is different from your Columns 3 & 4
1-Jan 1-Jan
1-Jan
1-Jan 2-Jan 3-Jan 4-Jan 4-Jan 4-Jan 4-Jan 4-Jan
5-Jan
6-Jan
7-Jan 8-Jan 8-Jan 8-Jan 8-Jan 8-Jan 8-Jan 8-Jan 0-Jan
9-Jan
9-Jan
9-Jan 12-Jan 12-Jan 12-Jan
13-Jan
13-Jan
13-Jan 15-Jan 16-Jan
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Yes, this is exactly what I want
But I want it by the formula
And very sorry for your trouble
I use (office 2003)
Please check the below formula will help you
in column 3
=IFERROR(VLOOKUP(D4,$E$4:$E$19,1,0),TEXT(0,"Genera l"))
in column 4
=IFERROR(VLOOKUP(E4,$D$4:$D$19,1,0),TEXT(0,"Genera l"))
It works until 8-Jan then stops. BTW there is an extra space between "a" and "l" for some reason that causes the formula to return #VALUE! errors.Please check the below formula will help you
I don't think you can do this via a formula. I could be wrong, but it needs a macro in my humble opinion.
Robert
Unfortunately, I think it will not work on (OFFICE 2003)
Thank you for your tired
Why not try and find out?Unfortunately, I think it will not work on (OFFICE 2003)
I have tried but did not work
Strange, they both worked for me
What error message(s) do you get when you run the either of code or what do you mean by it did not work?
@ Trebor76
IFERROR won't work in pre-2007 versions.
try this
=if(isnumber(match(D4,$E$4:$E$19,0)),VLOOKUP(D4,$E $4:$E$19,1,0),TEXT(0,"Genera l"))
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks