LinkBack URL
About LinkBacks
I need vlookup on cell E13 according date range which is F4 and F5 . Its showing last month value.
It should show value with Employee id 101 with 01/12/2015 to 31/12/2015 on E13 is 4426.
help me
Check attachment
I need vlookup on cell E13 according date range which is F4 and F5 . Its showing last month value.
It should show value with Employee id 101 with 01/12/2015 to 31/12/2015 on E13 is 4426.
help me
Check attachment
Last edited by hsc14; 01-02-2016 at 04:45 AM.
Can you provide a file without a macro? I prefer not to open Excel files with macros embedded - sorry.
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.
can u check the attachment now , its without macro.
Your formula is only matching the employee ID, and is therefore returning the first entry on the salary data sheet that matches. You need to use an INDEX MATCH formula that references the employee ID AND the date. I will create one for you in a moment.
concatenate emp id with date on both sheets and then apply vllokup.
thanks, I am waiting you helpful formula
Try
E13=SUMPRODUCT((Sal_data!$A$5:$A$47>=Emp_Slip!$F$4)*(Sal_data!$A$5:$A$47<=Emp_Slip!$F$5)*(Sal_data!$B$5:$B$47=Emp_Slip!$C$6)*(Sal_data!$E$5:$E$47))
Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
could you give me example pls
Try this in E13:
=INDEX(Sal_data!$E$5:$E$48,MATCH(1,INDEX((Sal_data!$B$5:$B$48=C6)*(Sal_data!$A$5:$A$48=F4),0),0))
What type example you want??? Is post 8 formula give not what you looking for??
I don't think he was replying to you - there are others, like yourself, who have added suggestions.Originally Posted by shukla.ankur281190
hsc14 I'm not sure what you are doing, you abruptly mark the other thread as solved and then I see this one. You seemed to think you still had a problem but without feedback or explanation you just mark the thread solved and disappear?
Other thread.
and another thread.
hsc14, are the other 2 threads of yours related to this 1?
the others are at...
http://www.excelforum.com/excel-prog...t-working.html
and
http://www.excelforum.com/excel-prog...ml#post4279904
If they are, please stay with 1 thread until it is resolved, otherwise you could be wasting other member's time, by having them work of something there, that might be solved here
If they are not the same, please tell me how they differ?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks