Aug 13 2019 01:05 PM
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!
Aug 13 2019 02:13 PM
Hi @cdsg21
It seems quite possible in Excel, please share your file of sample data so suitable formula can be provided.
Tauqeer
Aug 13 2019 02:38 PM
For such sample
the formula could be
=IFERROR(INDEX($C$3:$C$8,MATCH($F4,B3:B8,0)),"no such member")
Aug 13 2019 02:44 PM
Aug 13 2019 02:49 PM