Matching certain index values to dates in a separate table

Hi!

Unfortunately I have encountered a problem which I do not manage to solve and I have started to despair.

The thing is that I have got a table (table 1) with several costumers, visiting my facilitation on different dates. In table 2 I have got an index value for some of these dates. What I want to do is to add the index value (if it exists) from table 2 to a column to the right of the date each costumer visits my facilitation in table 1.
For a visualisation of the concept, please see the attachment.




I would very much appreciate any help on the issue.








Best regards,
Mathias

Use

=IFERROR(VLOOKUP(A1,'Table 2'!A:B,2,FALSE),"")