Home

Easy formula to simplify form

%3CLINGO-SUB%20id%3D%22lingo-sub-803379%22%20slang%3D%22en-US%22%3EEasy%20formula%20to%20simplify%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803379%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20everyone%20!%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20really%20need%20your%20help!%20it's%20been%202%20hours%20that%20i'm%20looking%20to%20find%20a%20formula%20to%20make%20my%20life%20easier%20with%20this%20excel%20form%20and%20I%20don't%20know%20where%20to%20look%20anymore%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20with%20the%20formula%20IF%20but%20I%20need%20it%20to%20work%20with%20Text%20and%20not%20numbers%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20members%20and%20a%20level%20of%20identification%20for%20everyone.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20new%20excel%20form%20i'm%20looking%20for%20a%20formula%20that%20will%20automaticly%20put%20the%20level%20of%20identification%20next%20to%20the%20member%20I%20will%20enter.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20making%20sense%3F%20Is%20it%20possible%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you%20for%20your%20help!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-803379%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-803429%22%20slang%3D%22en-US%22%3ERe%3A%20Easy%20formula%20to%20simplify%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803429%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F391817%22%20target%3D%22_blank%22%3E%40cdsg21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20quite%20possible%20in%20Excel%2C%20please%20share%20your%20file%20of%20sample%20data%20so%20suitable%20formula%20can%20be%20provided.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803465%22%20slang%3D%22en-US%22%3ERe%3A%20Easy%20formula%20to%20simplify%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803465%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F391817%22%20target%3D%22_blank%22%3E%40cdsg21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20such%20sample%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126853iA48B356F369F02C5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ethe%20formula%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-ruby%22%3E%3CCODE%3E%3DIFERROR(INDEX(%24C%243%3A%24C%248%2CMATCH(%24F4%2CB3%3AB8%2C0))%2C%22no%20such%20member%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803479%22%20slang%3D%22en-US%22%3ERe%3A%20Easy%20formula%20to%20simplify%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803479%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3EHere%20is%20a%20file%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803494%22%20slang%3D%22en-US%22%3ERe%3A%20Easy%20formula%20to%20simplify%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20file%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803495%22%20slang%3D%22en-US%22%3ERe%3A%20Easy%20formula%20to%20simplify%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803495%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-ruby%22%3E%3CCODE%3E%3DINDEX(Tableau1%5BLevel%5D%2CMATCH(Template!%24F5%2CTableau1%5BName%5D%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F391817%22%20target%3D%22_blank%22%3E%40cdsg21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803502%22%20slang%3D%22en-US%22%3ERe%3A%20Easy%20formula%20to%20simplify%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803502%22%20slang%3D%22en-US%22%3EThat's%20perfect!%20Thank%20you!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803514%22%20slang%3D%22en-US%22%3ERe%3A%20Easy%20formula%20to%20simplify%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803514%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F391817%22%20target%3D%22_blank%22%3E%40cdsg21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
cdsg21
New Contributor

Hey everyone ! 


I really need your help! it's been 2 hours that i'm looking to find a formula to make my life easier with this excel form and I don't know where to look anymore

 

I tried with the formula IF but I need it to work with Text and not numbers 

 

I have a list of members and a level of identification for everyone. 

 

In my new excel form i'm looking for a formula that will automaticly put the level of identification next to the member I will enter. 

 

Is it making sense? Is it possible? 


Thank you for your help! 

 

6 Replies

Hi @cdsg21 

 

It seems quite possible in Excel, please share your file of sample data so suitable formula can be provided.

 

Tauqeer

@cdsg21 

For such sample

clipboard_image_0.png

the formula could be

=IFERROR(INDEX($C$3:$C$8,MATCH($F4,B3:B8,0)),"no such member")

@tauqeeracma 

Here is the file 

Thanks for your help!

 

=INDEX(Tableau1[Level],MATCH(Template!$F5,Tableau1[Name],0))

@cdsg21 

That's perfect! Thank you!

@cdsg21 

You are welcome