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
Iserror function in excel with vlookup - Guide
Transfer data from one excel worksheet to another automatically vlookup - Guide
Copying Excel data from one sheet to another based upon contents of a cell - Excel Forum
Vlookup if two cells match return value from third - Excel Forum
How to use vlookup to match data from different sheets - Office Software 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.

Removing "FALSE" from an IF statement with a VLOOKUP

Comparing columns and returning value

Excel 2007 Using vlookup function in VBA

Compare values in two columns and return the value from third

Similar discussions

Subscribe To Our Newsletter!