Hi all,
This could be simple task for experts, i believe
I have a table of data in sheet1, which have userid wise numbers delivered for each date.
and i have sheet2 in which upon entering Id, respective numbers should populate for each of the dates.
Need a better formula solution.
Attached sample file.
Thank you
If I have helped you in someway, use the * icon below to give reputation feedback, it is appreciated.
1. You need to check your ID values, you left an 8 out of the ID in sheet 2
2. Put this in B5 and copy down as needed...
=IFERROR(INDEX(Sheet1!$C$2:$J$8,MATCH(Sheet2!$B$1&Sheet2!$B$2,INDEX(Sheet1!$B$2:$B$8&Sheet1!$A$2:$A$8,0),0),MATCH(Sheet2!$A5,Sheet1!$C$1:$J$1,0)),0)
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
"B5"Formula:
Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thanks to Fdibbins and avk, both the solution worked. appreciate your effort.
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks