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
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
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