Forum Discussion
cdsg21
Aug 13, 2019Copper Contributor
Easy formula to simplify form
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 th...
SergeiBaklan
Aug 13, 2019Diamond Contributor
For such sample
the formula could be
=IFERROR(INDEX($C$3:$C$8,MATCH($F4,B3:B8,0)),"no such member")- cdsg21Aug 13, 2019Copper ContributorThat's perfect! Thank you!
- SergeiBaklanAug 13, 2019Diamond Contributor
You are welcome