index/match formula to return name based on apha letter help

[lilsnoop]

Hello,

I was hoping someone could assist me with a formula that will identify a letter in cell B40 (which will change) and based on the letter it will return a name column C65 to C67. Each named individual will have apha letters ranging from their individual row extending from column E to P. I tried use something like this formula but I keep getting an error:

Please Login or Register  to view this content.

The formula would go in cell B64.

Thanks for your time!

[JohnTopley]

=iferror(index($c$65:$c$67,sumproduct(($e$65:$p$67=$b$40)*(row($1:$3)))),"")

[lilsnoop]

Thanks JohnTopley! That worked perfectly!