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

Comparing columns and returning value
ll -
kittu -

35 responses
Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses
Lookup partial text contained in cell range
Tom -
Tom -

4 responses
Using Vlookup to return insted of 00/01/1900
Tom9o -
tom9o -

2 responses
add/subtract & vlookup formula
sudhir -
sudhir -

2 responses