How would i find a location of an item using VLOOKUPS?

on Sheet 1 i have a list of items and when they have been delivered to a certain location On Sheet 2 i have a list of items and i need to find out where that item is.

For Example: on sheet 1 item 1 has been delivered to Location A then delivered to location B and item 3 has been delivered to location A but not taken to Location B. On sheet 2 it should tell me that item 1 is currently at Loaction B and item 3 is currently At location A (The "Item" Name will be mixed with Text, Numbers and Dashes. Ie. A-B34 )

Sheet 1

Column A = Item Column B = Delivered to Location A Column C - Delivered to Location B

     A           B            C        

+------------+------------+------------+ 1 | Item 1 | 28-01-2020 | 29-01-2020 | +------------+------------+------------+ 2 | Item 3 | 28-01-2020 | | +------------+------------+------------+ 3 | Item 4 | 28-01-2020 | | +------------+------------+------------+ 4 | Item 2 | 28-01-2020 | 29-01-2020 | +------------+------------+------------+

Sheet 2

Column A = Item Column B = Location

     A           B        

+------------+------------+ 1 | Item 1 | Location B | +------------+------------+ 2 | Item 2 | location A | +------------+------------+ 3 | Item 4 | Location B | +------------+------------+

Thanks in advance