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

@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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies