Help on a similar VLOOKUP function

[EmilAlteryx01]

Im attempting to add a coloumn- similar to the vlookup foundation - Based on the OrderID - and then get one table with the Employee ID against the OrderID 

Input File 1
OrderID	Name	Cost	Style	Fabric
747380	Kevin	1500	Tops	Cotton
747896	Mark	1500	Tops	Denim
787985	Mary	1000	Tops	Organza
759876	Rose	1000	Bottoms	Cotton
758964	John	2000	Bottoms	Silk

Input File 2
OrderID	Employee ID
758964	874563
787944	625741
747380	125478
759876	963753
747896	159357
758963	963755
787985	963258
747311	111585
759800	111586
747159	158742

Output required 

Output
OrderID	Name	Cost	Style	Fabric	Employee ID
747380	Kevin	1500	Tops	Cotton	125478
747896	Mark	1500	Tops	Denim	159357
787985	Mary	1000	Tops	Organza	963258
759876	Rose	1000	Bottoms	Cotton	963753
758964	John	2000	Bottoms	Silk	874563

[Luke_C · Accepted solution]

Hi @EmilAlteryx01 

You'd just use a join tool on OrderID to get this output:

[EmilAlteryx01]

Thanks Luke - I have used this to review where my output is breaking