Home

Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul

%3CLINGO-SUB%20id%3D%22lingo-sub-842148%22%20slang%3D%22en-US%22%3EPulling%20data%20from%20MenaData%20and%20BioData%20in%20result%20sheet%20based%20on%20employee%20id%20and%20then%20result%20in%20resul%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842148%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EDear%20Gentlemen%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20three%20excel%20sheet%20in%20an%20excel%20workbook.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E1.%20I%20want%20to%20pull%20data%20from%20menaData%20sheet%20from%2016-8-19%20to%2015-9-19%20based%20on%20employee%20id%20put%20on%20result%20sheet%20B4.%20i.e%20for%20e.g%20i%20put%20employee%20id%2024576.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2.%20I%20want%20to%20pull%20data%20fromBioData%20sheet%20from%2016-8-19%20to%2015-9-19%20based%20on%20employee%20id%20put%20on%20result%20sheet%20B5.%20i.e%20for%20e.g%20i%20put%20employee%20id%2024576.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E3.%20In%20Result%20sheet%20i%20want%20to%20verify%20for%20employee%20id%2024576%20either%20it%20is%20true%20or%20false%20in%20cell%20range%20menaData%20C4%3AAG4%20and%20bioData%20cell%20range%20C5%3AAG5%2C%20the%20result%20in%20result%20sheet%20c6%2C%20d6%20and%20so%20on%20till%2015-9-19%20or%20available%20data.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eawaiting%20your%20response....%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ERef.%20attached%20file%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ERegards%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Ealigahk06%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842148%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842171%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20data%20from%20MenaData%20and%20BioData%20in%20result%20sheet%20based%20on%20employee%20id%20and%20then%20result%20in%20r%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842171%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ESir%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EPullimg%20data%20coulmn%20value%20for%20menaData%20is%20B4%20%2C%20C4%20AND%20SO%20ON%20UNTIL%20AF4%20for%20employee%20id%2024576%20from%20menaData%20like%20retuen%20data%20dayoff%20%2C%2008%3A00%3A00%20AM%20TO%2004%3A00%3A00%20PM%20and%20so%20on%20.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EPullimg%20data%20coulmn%20value%20for%20bioData%20is%20B5%20%2C%20C5%20AND%20SO%20ON%20UNTIL%20AF5%20for%20employee%20id%2024576.%20from%20BioData%20return%20column%20value%20timetable%20Range%20E%3AE%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThen%20match%20in%20result%20sheet%20true%20or%20false%20based%20on%20above%20two%20column%20data%20one%20by%20one%20in%20corresponding%20cell.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Abdul H Khan
Occasional Contributor

Dear Gentlemen,

I have three excel sheet in an excel workbook.
1. I want to pull data from menaData sheet from 16-8-19 to 15-9-19 based on employee id put on result sheet B4. i.e for e.g i put employee id 24576.
2. I want to pull data fromBioData sheet from 16-8-19 to 15-9-19 based on employee id put on result sheet B5. i.e for e.g i put employee id 24576.
3. In Result sheet i want to verify for employee id 24576 either it is true or false in cell range menaData C4:AG4 and bioData cell range C5:AG5, the result in result sheet c6, d6 and so on till 15-9-19 or available data.

awaiting your response....

Ref. attached file
Regards,
aligahk06

1 Reply

Sir,

Pullimg data coulmn value for menaData is B4 , C4 AND SO ON UNTIL AF4 for employee id 24576 from menaData like retuen data dayoff , 08:00:00 AM TO 04:00:00 PM and so on .
Pullimg data coulmn value for bioData is B5 , C5 AND SO ON UNTIL AF5 for employee id 24576. from BioData return column value timetable Range E:E

Then match in result sheet true or false based on above two column data one by one in corresponding cell. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies