Connect tables

Hi!

I have 2 tables in 2 sheets.
Screenshot_138.jpg
Screenshot_139.jpg
I need to have a formula that automatically puts value from Sheet 2 B column to Sheet 1 D column. Any ideas?

I tried to use VLOOKUP function using Event&Name to put unique values for each table but somehow it is not working. What am I doing wrong?
Screenshot_140.jpg
Screenshot_141.jpg

You get a good score for effort

For that to work with vlookup, Event&Name in sheet2 needs to be in A2:A13, not D2:D13. The column that the criteria matches to must be in the first column of the lookup range.

If you want to match the criteria to any other column then you need to use index and match

=INDEX(Sheet2!$B$2:$B$13;MATCH(E2;Sheet2!$D$2:$D$13;FALSE))

Thank you, you're golden!