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.

Please help. Vlookup thing..not sure
If iserror vlookup - Guide
Transfer data from one excel worksheet to another automatically vlookup - Guide
Automatically transfer data from one sheet to another ✓ - 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

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

Similar discussions

How to invoke VLookUp function in Excel VBA.

Compare values in two columns and return the value from third

VlookUp Problem?

Excel 2007 Using vlookup function in VBA

Concanating text using vlookup forumula

Similar discussions

Subscribe To Our Newsletter!