Home

excel function question

%3CLINGO-SUB%20id%3D%22lingo-sub-412685%22%20slang%3D%22en-US%22%3Eexcel%20function%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-412685%22%20slang%3D%22en-US%22%3E%3CP%3E1.%20I%20have%20a%20list%20of%20codes%20and%20would%20like%20to%20generate%20a%20list%20of%20codes%20that%20are%20in%20Column%20A%20from%20Sheet%201%20and%20not%20in%20column%20A%20of%20Sheet2%20and%20return%20the%20value%20in%20column%20B%20from%26nbsp%3B%20Sheet%201%20of%20the%20codes%20that%20populate%20sheet3%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20If%20that%20is%20not%20possible%20I%20am%20looking%20for%20a%20way%20to%20generate%20a%20list%20of%20codes%20in%20column%20a%20of%20sheet%20one%20if%20a%20specific%20word%20is%20found%20in%20column%20b%20of%20sheet%201.%26nbsp%3B%20I%20would%20search%20by%20the%20name%20of%20the%20medication.%20The%20medication%20can%20be%20listed%20with%20an%20order%20sentence%20or%20without.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EData%20set%20example%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E123455%3C%2FTD%3E%3CTD%3E50%20ML%20argatroban%201%20MG%2FML%20Injection%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E122345%3C%2FTD%3E%3CTD%3E125%20ML%20argatroban%201%20MG%2FML%20Injection%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1223455%3C%2FTD%3E%3CTD%3E250%20ML%20argatroban%201%20MG%2FML%20Injection%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1223%3C%2FTD%3E%3CTD%3Eargtroban%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-412685%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-413443%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20function%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-413443%22%20slang%3D%22en-US%22%3EPlease%20provide%20a%20specific%20example%20of%20the%20data%20and%20result%20you%20want.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-415136%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20function%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-415136%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F279450%22%20target%3D%22_blank%22%3E%40kmb06002%3C%2FA%3E%26nbsp%3B%2C%20that%20could%20be%20done%20with%20Power%20Query.%203%20steps%3C%2FP%3E%0A%3CP%3E-%20query%20first%20table%3C%2FP%3E%0A%3CP%3E-%20query%20second%20table%3C%2FP%3E%0A%3CP%3E-%20merge%20first%20table%20with%20second%20one%20with%20Left%20Anti%20and%20land%20the%20resulting%20table%20with%20values%20from%20first%20table%20for%20which%20codes%20are%20not%20in%20second%20one.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20434px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106328i4E0FEAB31C240CAA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
kmb06002
Frequent Visitor

1. I have a list of codes and would like to generate a list of codes that are in Column A from Sheet 1 and not in column A of Sheet2 and return the value in column B from  Sheet 1 of the codes that populate sheet3

 

2. If that is not possible I am looking for a way to generate a list of codes in column a of sheet one if a specific word is found in column b of sheet 1.  I would search by the name of the medication. The medication can be listed with an order sentence or without. 

 

Data set example

 

12345550 ML argatroban 1 MG/ML Injection
122345125 ML argatroban 1 MG/ML Injection
1223455250 ML argatroban 1 MG/ML Injection
1223argtroban
2 Replies
Please provide a specific example of the data and result you want.

@kmb06002 , that could be done with Power Query. 3 steps

- query first table

- query second table

- merge first table with second one with Left Anti and land the resulting table with values from first table for which codes are not in second one.

image.png

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
11 Replies