Hi all :-)
I was fighting with vlookup and indirect function, but not successfully :-((
I have a simple workbook split into Monthly sheets per employee ( e.g. January February etc) and Whole Year 2016 ( called Yearly Plan).
What I need is to lookup value from "Yearly Plan sheet" into monthly sheets. Basically if any code example "Vacation" will be added into Yearly Plan for particular date, it will be visible in sheet for that Month and employee :-)
Thank you,
Andy
may be below in K12
Formula:
Please Login or Register to view this content.
removing if function will give you zeros, that can be taken care using conditional formatting as yellow colour of font for all zeros
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Hi,
thank you.
When checked I figure out, that forgot something to add in my file.
Each employee could should have 2 rows ( sending revised file), for that reason my function was not working
Andy
A few suggestions on your layout...
1. It is almost always better to have a table that grows downwards (ie dates going down) rather than across
2. Have you considered just using the summary sheet and the layout above, then using filters to just show the month you want?
3. Why the need for a sheet for each person?
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
A few suggestions on your layout...
1. It is almost always better to have a table that grows downwards (ie dates going down) rather than across
2. Have you considered just using the summary sheet and the layout above, then using filters to just show the month you want?
3. Why the need for a sheet for each person?
Hi, its business requirements. Have to update manually Yearly plan a based on that to fill monthli wise via function.
Are u able to help me? Or anybody else?
Try
in I12
=IFERROR(INDEX('Yearly Plan'!$I$12:$N$25,MATCH(January!$B12,'Yearly Plan'!$B$12:$B$25,0),MATCH(January!I$11,'Yearly Plan'!$I$11:$N$11,0)),"")
in I13
=IFERROR(INDEX('Yearly Plan'!$I$12:$N$25,MATCH(January!$B12,'Yearly Plan'!$B$12:$B$25,0)+1,MATCH(January!I$11,'Yearly Plan'!$I$11:$N$11,0)),"")
Copy in PAIRS to I14, I16 .etc then drag across columns
Format cells as 0;0;;@ to hide 0s (zeros)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks