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:
=IFERROR(INDEX($C$65:$P$67,SMALL(IF(INDEX($C$65:$P$67,,13)=B40,MATCH(ROW($C$65:$P$67),""),ROWS($C$9:$C$9),COLUMNS($C$9:$C$9)),"Not Found")
The formula would go in cell B64.
Thanks for your time!
Bookmarks