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
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. 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.
Related:
- Please help. Vlookup thing..not sure
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Excel 2007 Using vlookup function in VBA ✓ - Excel Forum
- Using Vlookup to return insted of 00/01/1900 ✓ - Excel Forum
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 3, 2010 at 01:23 PM
May 3, 2010 at 01:23 PM
