Home

Priority formula

%3CLINGO-SUB%20id%3D%22lingo-sub-504437%22%20slang%3D%22en-US%22%3EPriority%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-504437%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20want%20to%20know%20if%20there%20and%20how%20we%20can%20use%20priority%20in%20a%20excel%20formula.%20I%20need%20to%20ask%20first%20to%20find%20the%20Day%20text%20in%20a%20cell%20from%20a%20date%20ex%3A%20Monday%204%2F15%2F2019%2C%20than%20with%20that%20name%20add%20a%20condition%20IF%2C%20so%20this%20will%20make%20IF%20Monday%2C%20display%20Lundi%2C%20and%20after%20that%20using%20a%20Index%2FMatch%20formula%20to%20look%20into%20another%20sheet%20and%20show%20the%20Opening%20time%20from%20that%20answer.%20ex%3A%20Lundi%20%3D%209h%20-%2015h.%20so%20is%20it%20possible%20to%20make%20the%20thing%20working%20in%20this%20order%20or%20not%3F%20can%20we%20make%20Excel%20looking%20thing%20be%20step%20in%20one%20formula%20or%20make%20a%20result%20to%20one%20cell%20and%20combine%20the%20answer%20with%20the%20other%20question%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-504437%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-504505%22%20slang%3D%22en-US%22%3ERe%3A%20Priority%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-504505%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F322589%22%20target%3D%22_blank%22%3E%40Natas20075%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20everything%20could%20be%20done%20with%20one%20formula%2C%20however%20quite%20often%20it's%20worth%20to%20use%20helper%20tables%2Fcolumns%20-%20easier%20with%20maintenance%20and%20you%20always%20may%20check%20intermediate%20results.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-505061%22%20slang%3D%22en-US%22%3ERe%3A%20Priority%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-505061%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOK%20thank%20for%20the%20answer%2C%20as%20I%20just%20start%20learning%20excel%2C%20I%20will%20look%20what%20that%20is%20and%20how%20to%20use%20that%20option.%20if%20you%20say%20that%20will%20be%20better%20and%20faster%2C%20then%20I%20will%20move%20that%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20Sergei%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Natas20075
Occasional Contributor

Hi,

I want to know if there and how we can use priority in a excel formula. I need to ask first to find the Day text in a cell from a date ex: Monday 4/15/2019, than with that name add a condition IF, so this will make IF Monday, display Lundi, and after that using a Index/Match formula to look into another sheet and show the Opening time from that answer. ex: Lundi = 9h - 15h. so is it possible to make the thing working in this order or not? can we make Excel looking thing be step in one formula or make a result to one cell and combine the answer with the other question etc.

 

thank you

 

2 Replies
Highlighted

@Natas20075 ,

 

Hi,

 

I guess everything could be done with one formula, however quite often it's worth to use helper tables/columns - easier with maintenance and you always may check intermediate results.

@Sergei Baklan 

OK thank for the answer, as I just start learning excel, I will look what that is and how to use that option. if you say that will be better and faster, then I will move that way.

 

thank Sergei

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies