Calling up and sorting from another sheet

[Mabes]

Hello All,

I am stumped! I hope I explain myself right here...

I am attempting to reprice a large number of items by grabbing the new MIN and MAX prices from Sheet2 and entering them into the correct cell of Sheet1. i have attached a small sample of what I am working with.

I want Sheet1 to find the matching SKU on Sheet2 and look across the row to find the New Min(Column H) and New Max (Column I) and enter those into Sheet1 Columns C and D.

Any help would be amazing and save me many days of work. I will have thousands of rows to sort through. Thank you everyone! If anything is unclear please ask!

[bebo021999]

Have you tried VLOOKUP:
=VLOOKUP(A2,Sheet2!$A$1:$I$11,8,0)

[Mabes]

I have been messing around with it a bit but am not too familiar with VLookup. What do the 8,0 represent at the end of the formula?

[Mabes]

Thank you a hundred times over. The more I read up about vlookup it was exactly what I was looking for. Thank you so much! How did I not know about this before?!?