Hello everyone,
I'm trying to create a work shift schedule on a calendar and I want to get the name of the employee from each day on the calendar to get in a table.
Look the picture attached to understand. Thank you very much.
Hello everyone,
I'm trying to create a work shift schedule on a calendar and I want to get the name of the employee from each day on the calendar to get in a table.
Look the picture attached to understand. Thank you very much.
Last edited by igones; 12-26-2019 at 11:29 AM.
Hi,
use Hlookup
=HLOOKUP(J3,$B$3:$H$4,2,FALSE)
Christopher Yap
Hello, thanks for your reply! But I want to search in the whole calendar (B3:H12), not only the first line. How can I do that?
Thanks again!
you can manually copy the formula (See yellow highlight)
I have not think of an efficient way of automate it as each year and month with different pattern from Sunday-Saturday,
therefore copying will be faster
Rgds
You are right, thanks! I am trying to automate, but that's very good so far.
Try this in K3 and copy down
=INDEX($B$3:$H$12,SUMPRODUCT(--($B$3:$H$12=J3)*ROW($B$3:$H$12))-ROW($B$3:$H$12)+2,SUMPRODUCT(--($B$3:$H$12=J3)*COLUMN($B$3:$H$12))-COLUMN($B$3:$H$12)+1)
Beth.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. As you are new here, we shall do tt for you this time.)
x posted
https://www.mrexcel.com/board/thread...table.1118802/
and
https://www.reddit.com/r/excel/comme...ndar_to_table/
Last edited by AliGW; 12-26-2019 at 02:58 AM. Reason: Links added by moderator - new member,
Amazing! Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks