Either vlookup or index and match. Vlookup will need the data in very specific locations but index and match used together will find what ever you want. If I wasn't on my phone is paste an example but there's plenty of instruction on those functions from me Google.
Bookmarks