Need Help - Multiple IFs and returns trimmed value

Hihi,
I need a formula to return me the trimmed value if it meets the multiple criterias I set.

Try to use the below formula but it does not work.

=IFERROR(INDEX($B5:$B5,1,MATCH("Jane",B5:B5,0)),IFERROR(INDEX($B5:$B5,1,MATCH("Steve",B5:B5,0)),IFERROR(INDEX($B5:$B5,1,MATCH("Mary",B5:B5,0)),IFERROR(INDEX($B5:$B5,1,MATCH("Harry",B5:B5,0)),INDEX($B5:$B5,1,MATCH("Jenny",B5:B5,0))))))

The above formula I used is only to return the value but I actually wanted a formula to provide me the trimmed value (meaning remove the characters from -xxxx) as well.

Attached is the sample table.

Appreciate all help!

Hi,
This formula 50% corrects! but at the same time, I want my return value to be the characters before the dash (meaning to trim off the characters from -xxxx).

=IFERROR(INDEX($B6:$B6,1,MATCH("*Jane",B6:B6,0)),IFERROR(INDEX($B6:$B6,1,MATCH("*Steve",B6:B6,0)),IFERROR(INDEX($B6:$B6,1,MATCH("*Mary",B6:B6,0)),IFERROR(INDEX($B6:$B6,1,MATCH("*Harry",B6:B6,0)),INDEX($B6:$B6,1,MATCH("*Jenny",B6:B6,0))))))

Thanks in advance.

Why not simple use the


=LEFT(B2,FIND("-",B2)-1)


What is point of checking the name?

I only want specific ones. The table has many combinations.

Therefore, the formula u given is too simplified.

=LEFT(B2,FIND("-",B2)-1)

Thanks, Glenn!

Your formula works for me! Appreciate