I need help writing an "IF" formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2698969%22%20slang%3D%22en-US%22%3EI%20need%20help%20writing%20an%20%22IF%22%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2698969%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20the%20following%20formula.%3C%2FP%3E%3CP%3EIf%20priority%20%3D%201%2C%20then%20copy%20information%20from%20above%20to%20this%20new%20location%20in%20unit%20descending%20numerical%20order.%20The%20file%20is%20attached%20below%20and%20the%20formula%20I%20need%20help%20with%20is%20highlighted%20in%20yellow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2698969%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2699542%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20writing%20an%20%22IF%22%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2699542%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1141459%22%20target%3D%22_blank%22%3E%40Pedro_Rossie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20better%20solution%2C%20which%20involves%20a%20bit%20of%20reorganizing.%20This%20uses%20%3CSTRONG%3EFILTER%3C%2FSTRONG%3E%20rather%20than%20%3CSTRONG%3EIF%3C%2FSTRONG%3E%2C%20but%20accomplishes%20what%20you%20want%20because%20FILTER%20incorporates%20the%20criterion%20in%20itself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20formula%3A%26nbsp%3B%3CSTRONG%3E%3DFILTER(Table1%2CTable1%5BPriority%5D%3D'Filtered%20Lists'!B1%2C%22None%22)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%2C%20to%20make%20a%20single%20formula%20work%2C%20you%20need%20to%20put%20those%20separate%20lists%20into%20a%20single%20database%2C%20going%20from%20201%20through%201102.%20It's%20always%20better%20to%20create%20single%20databases%20(tables)%20than%20to%20separate%20them%20as%20you%20had%20done.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20that%20was%20done%2C%20the%20FILTER%20function%20readily%20works%20to%20select%20whatever%20category%20you%20want.%20Here's%20what%20the%20end%20result%20looks%20like%20for%20Priority%3D1.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1630343921223.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306721i5B8DE34B5A36F543%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mathetes_0-1630343921223.png%22%20alt%3D%22mathetes_0-1630343921223.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3BAnd%20here%20it%20is%20for%20Priority%20%3D%202%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_1-1630343989330.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306722iFC827391F69CE75B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mathetes_1-1630343989330.png%22%20alt%3D%22mathetes_1-1630343989330.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EBy%20the%20way%2C%20you%20should%20not%20have%20posted%20that%20file--unless%20those%20names%20were%20fictitious.%20That's%20why%20I've%20changed%20all%20names%20to%20%22MickeyMouse.%22%20I'd%20recommend%20you%20take%20down%20your%20original%20immediately.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need help with the following formula.

If priority = 1, then copy information from above to this new location in unit descending numerical order. The file is attached below and the formula I need help with is highlighted in yellow.

1 Reply

@Pedro_Rossie 

 

Here's a better solution, which involves a bit of reorganizing. This uses FILTER rather than IF, but accomplishes what you want because FILTER incorporates the criterion in itself.

 

Here's the formula: =FILTER(Table1,Table1[Priority]='Filtered Lists'!B1,"None")

 

First, to make a single formula work, you need to put those separate lists into a single database, going from 201 through 1102. It's always better to create single databases (tables) than to separate them as you had done.

 

Once that was done, the FILTER function readily works to select whatever category you want. Here's what the end result looks like for Priority=1. 

mathetes_0-1630343921223.png

 And here it is for Priority = 2

mathetes_1-1630343989330.png

By the way, you should not have posted that file--unless those names were fictitious. That's why I've changed all names to "MickeyMouse." I'd recommend you take down your original immediately.