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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies