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
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies