Previous Topic Next Topic

Please help. Vlookup thing..not sure

Closed
Pedie - May 3, 2010 at 01:13 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 3, 2010 at 01:23 PM
Please help! I have a schedule@ which looks like this. In sheet1 A2:A13 has names of workers. B2:B30 has dates in serial wise. B3:S13 has the shift timings or text "L" for people on Leave and text "W off" for people on week offs. I want the formula to be entered in sheet1 A15 or macro.

1. When I run the formula/macro for the date example "4/3/2010" in the A15 or macro button, I want list of names comes in serial wise from A16.
2. Which means it will display the name of people who is present or will be present on that particular day.
Thanks a lot.

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 3, 2010 at 01:23 PM
duplicate to https://ccm.net/forum/affich-337695-please-help-vlookup-thing-not-sure
0

Similar discussions

Concanating text using vlookup forumula
gannesh0604 -
gannesh0604 -

0 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Conditional Formatting in a vlookup
attycuz -
TrowaD -

1 response
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses
Automatically transfer data from one sheet to another
sunny49er -
TrowaD -

22 responses