LinkBack URL
About LinkBacks
I have attached a file for find a value from using a date and month.
Can you please help me for the formula that can solve the problem
if I replace jul'24 with 7 then get result otherwise NA
PLEASE HELP ME MAM
Can you please help to find the value using date
I have attached a file for find a value from using a date and month.
Can you please help me for the formula that can solve the problem
if I replace jul'24 with 7 then get result otherwise NA
PLEASE HELP ME MAM
Last edited by deven03; 08-01-2024 at 05:28 AM.
Have you tried to adapt what you were given in your previous thread? Please have a go and then attach your attempt. Otherwise you won't learn anything.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
If you can't work it out, try this:
=VLOOKUP("SAL "&TEXT(D6,"mmm")&"'"&TEXT(D6,"yy"),A6:B17,2,0)
Did you see my note in your olther thread about the Report button?
You can use this formula in cell E6:
=VLOOKUP(TEXT($D$6,"\SAL mmm'yy"),$A$6:$B$17,2,0)
Format the cell in the style you prefer.
Hope this helps.
Pete
Could you please stop reporting my posts? Use the Report button for something BAD. If yo want to thank a member for their help, please use the Reputation button instead. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks