Problem with Lookup Function Autofilling a column

[Scott_Weir]

I want autofill a column when it matches another column from another table. Full explanation in the image attached below! Would greatly appreciate the help!

[Ander]

@Scott_Weir

1/2

---

2/2