Home

IF Function help!

%3CLINGO-SUB%20id%3D%22lingo-sub-528981%22%20slang%3D%22en-US%22%3EIF%20Function%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528981%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20formula%20that%20will%20copy%20a%20row%20if%20a%20specified%20field%20contains%20a%20specified%20value.%26nbsp%3B%20For%20example%2C%20in%20the%20below%20sheet%2C%20I%20would%20like%20to%20copy%26nbsp%3B%20the%201st%20row%20to%20the%20Complete%20tab%2C%202nd%20row%20to%20Fail%20tab%20and%203rd%20to%20Pass%20tab.%26nbsp%3B%20Is%20this%20possible%2C%20if%20so%20what%20would%20the%20formula%20be%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E3%2F25%2F2019%3C%2FTD%3E%3CTD%3E7%3A15%20AM%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3ENotification%20to%20Testers%3C%2FTD%3E%3CTD%3ESend%20notification%20to%20testers%20of%20scheduled%20tests%20for%20the%20day%3C%2FTD%3E%3CTD%3E%3CP%3EJohn%3C%2FP%3E%3C%2FTD%3E%3CTD%3EComplete%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%2F25%2F2019%3C%2FTD%3E%3CTD%3E7%3A30%20AM%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EUpdate%20Params%26nbsp%3B%3C%2FTD%3E%3CTD%3EUpdate%20params%26nbsp%3B%3C%2FTD%3E%3CTD%3EJosie%3C%2FTD%3E%3CTD%3EFail%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%2F25%2F2019%3C%2FTD%3E%3CTD%3E7%3A30%20AM%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EProjected%20Pmt%20Int%3C%2FTD%3E%3CTD%3EValidate%20DTCC's%20Projected%20Payments%26nbsp%3B%3C%2FTD%3E%3CTD%3EEmma%3C%2FTD%3E%3CTD%3EPass%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-528981%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-529159%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-529159%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F333209%22%20target%3D%22_blank%22%3E%40dtripp_1961%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20want%20to%20copy%2C%20not%20to%20move%2C%20you%20may%20use%20Power%20Query%20quering%20first%20sheet%20and%20land%20filtered%20results%20into%20other%20sheets.%3C%2FP%3E%3C%2FLINGO-BODY%3E
dtripp_1961
Occasional Visitor

I am trying to create a formula that will copy a row if a specified field contains a specified value.  For example, in the below sheet, I would like to copy  the 1st row to the Complete tab, 2nd row to Fail tab and 3rd to Pass tab.  Is this possible, if so what would the formula be?

 

3/25/20197:15 AM1Notification to TestersSend notification to testers of scheduled tests for the day

John

Complete
3/25/20197:30 AM2Update Params Update params JosieFail
3/25/20197:30 AM3Projected Pmt IntValidate DTCC's Projected Payments EmmaPass 
1 Reply

@dtripp_1961 , if you want to copy, not to move, you may use Power Query quering first sheet and land filtered results into other sheets.

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