busy small business owner needs help! (functions)

%3CLINGO-SUB%20id%3D%22lingo-sub-1657865%22%20slang%3D%22en-US%22%3Ebusy%20small%20business%20owner%20needs%20help!%20(functions)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1657865%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20quickly%20fix%20and%20update%20some%20sheets%20my%20team%20has%20created.%20Id%20like%20to%20return%20a%20result%20to%20cells%20on%20a%20new%20sheet%20based%20upon%20input%20on%20a%20first%20sheet.%20The%20example%20I%20pose%20goes%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20my%20production%20team%20member%20completes%20a%20product%20fabrication%2C%20it%20is%20logged%20on%20a%20sheet%20with%20date%20of%20completion%20(or%20could%20be%20a%20simple%20checkbox).........id%20like%20this%20data%20to%20be%20auto-populated%20into%20another%20sheet%20kept%20by%20my%20financial%20and%20administrative%20team%20to%20prompt%20action%20by%20them.%20Im%20pretty%20sure%20based%20on%20my%20novice%20level%20understanding%20that%20an%20%22IF%22%20logical%20argument%20function%20is%20where%20to%20start.............%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20one%20of%20you%20experienced%20folks%20help%3F%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bthanks%20so%20much%20in%20advance%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1657865%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1658160%22%20slang%3D%22en-US%22%3ERe%3A%20busy%20small%20business%20owner%20needs%20help!%20(functions)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1658160%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F790491%22%20target%3D%22_blank%22%3E%40ramdds%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20need%20to%20find%20all%20the%20matches%20in%20a%20list.%20Below%20web%20page%20contains%20a%20formula%20to%20find%20all%20the%20corresponding%20matches%20and%20retrieve%20data.%20It%20is%20in%20Turkish%20however%20you%20can%20use%20translator%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CA%20href%3D%22http%3A%2F%2Fexcelileharikalar.com%2Findex.php%2F2019%2F04%2F24%2Ftum-eslesenleri-cekme%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fexcelileharikalar.com%2Findex.php%2F2019%2F04%2F24%2Ftum-eslesenleri-cekme%2F%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need to quickly fix and update some sheets my team has created. Id like to return a result to cells on a new sheet based upon input on a first sheet. The example I pose goes like this:

 

when my production team member completes a product fabrication, it is logged on a sheet with date of completion (or could be a simple checkbox).........id like this data to be auto-populated into another sheet kept by my financial and administrative team to prompt action by them. Im pretty sure based on my novice level understanding that an "IF" logical argument function is where to start.............

 

Can one of you experienced folks help?     thanks so much in advance  

1 Reply

@ramdds 

 

you need to find all the matches in a list. Below web page contains a formula to find all the corresponding matches and retrieve data. It is in Turkish however you can use translator

 

http://excelileharikalar.com/index.php/2019/04/24/tum-eslesenleri-cekme/