Home

Need a solution to go down a list of names on one workbook and return maches from another

%3CLINGO-SUB%20id%3D%22lingo-sub-807583%22%20slang%3D%22en-US%22%3ENeed%20a%20solution%20to%20go%20down%20a%20list%20of%20names%20on%20one%20workbook%20and%20return%20maches%20from%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807583%22%20slang%3D%22en-US%22%3EExcel%20experience%20very%20basic%2C%20I%20rely%20on%20Google%20and%20asking%20the%20right%20question%20for%20need%20specific%20solutions.%20This%20one%20has%20got%20me%20stumped%20I%20have%202%20lists%20on%20in%20two%20different%20workbooks%20One%20is%20a%20specific%20list%20of%20patients%20the%20other%20is%20a%20list%20of%20all%20patients%20that%20have%20had%20a%20particular%20set%20of%20labs%20done%20during%20a%20specified%20time%20period.%20I%20have%20been%20able%20to%20compare%20the%20two%20and%20identify%20which%20patients%20on%20my%20list%20also%20appear%20on%20my%20larger%20lab%20list.%20%3DIF(ISNA(MATCH(%22*%22%26amp%3BA3%26amp%3B%22*%22%2C'list%2C0))%2C%22NO%22%2C%22YES%22)%20'Yes'%20their%20specific%20ID%23%20appears%20on%20the%20lab%20list%20or%20'No'%20it%20doesn't.%20That%20same%20lab%20list%20gives%20the%20date%2C%20name%20of%20the%20specific%20labs%20and%20the%20results%20in%20multiple%20columns%20with%20an%20individual%20row%20(headed%20by%20a%20string%20that%20contains%20the%20patient%20ID%23)%20for%20each%20test.%20Snuffy%2CJoe12345%2Ftest%20date%2Fspecific%20lab1%2Fresults1_1%2Fresults2_1%2Fresults3_1%20Snuffy%2CJoe12345%2Ftest%20date%2Fspecific%20lab2%2Fresults1_2%2Fresults2_2%2Fresults3_2%20I%20would%20like%20to%20be%20able%20to%20go%20down%20the%20specific%20patient%20list%20and%20add%20to%20it%20the%20aforementioned%20data%20points%20for%20each%20patient%20that%20matches%20up%20Final%20product%20would%20look%20something%20like%3A%20Column1%2FColumn2%2FColumn3%2FColumn4%2FColumn5%20Snuffy%2CJoe12345%2FYes%2F%20test%20date%2Fspecific%20lab1%2Fresults1_1%2Fresults2_1%2Fresults3_1%20test%20date%2Fspecific%20lab2%2Fresults1_2%2Fresults2_2%2Fresults3_2%20Boop%2CBetty35698%2F%20No%20Blow%2CJoe98745%2FYes%20test%20date%2Fspecific%20lab1%2Fresults1_1%2Fresults2_1%2Fresults3_1%20all%20the%20way%20down%20my%20list%20of%20patients.%20I%20have%20not%20been%20able%20to%20search%20a%20solution%2C%20probably%20due%20to%20my%20wording%20of%20my%20query.%20Any%20assistance%2C%20even%20if%20it's%20just%20enough%20to%20get%20me%20moving%20in%20right%20direction%20would%20be%20greatly%20appreciated%20Tusen%20Takk!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-807583%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
zond2
New Contributor
Excel experience very basic, I rely on Google and asking the right question for need specific solutions. This one has got me stumped I have 2 lists on in two different workbooks One is a specific list of patients the other is a list of all patients that have had a particular set of labs done during a specified time period. I have been able to compare the two and identify which patients on my list also appear on my larger lab list. =IF(ISNA(MATCH("*"&A3&"*",'list,0)),"NO","YES") 'Yes' their specific ID# appears on the lab list or 'No' it doesn't. That same lab list gives the date, name of the specific labs and the results in multiple columns with an individual row (headed by a string that contains the patient ID#) for each test. Snuffy,Joe12345/test date/specific lab1/results1_1/results2_1/results3_1 Snuffy,Joe12345/test date/specific lab2/results1_2/results2_2/results3_2 I would like to be able to go down the specific patient list and add to it the aforementioned data points for each patient that matches up Final product would look something like: Column1/Column2/Column3/Column4/Column5 Snuffy,Joe12345/Yes/ test date/specific lab1/results1_1/results2_1/results3_1 test date/specific lab2/results1_2/results2_2/results3_2 Boop,Betty35698/ No Blow,Joe98745/Yes test date/specific lab1/results1_1/results2_1/results3_1 all the way down my list of patients. I have not been able to search a solution, probably due to my wording of my query. Any assistance, even if it's just enough to get me moving in right direction would be greatly appreciated Tusen Takk!
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