Searching various columns for matching cells - then return corresponding value

[JMusch]

Hey there.

I am trying to 'complete' a column where i must input values from different columns on different tabs.
I put what i wanted to do more specifically into the example. I think it should be pretty clear but if it's not, let me know!

Thanks in advance!

[JohnTopley]

in d2

=IFERROR(INDEX('Y1'!$D$2:$D$15,MATCH('-'!$B3,'Y1'!$B$2:$B$15,0)),"")

Change Y1 to Y2 and Y3 for columns E and F