Easy formula to simplify form

Copper 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