i have 2 worksheets

First worksheet contains 2 columns - machinename and problems -totally 150 enntries
2nd sheet contains 3 columns machinename, owner and location -totally 10000 entries

I need to be able to fetch owner,locations for all machinenames in sheet 1

Please share the steps or formula for the same.