This might be easy for you but i need to use one vlookup formula since i am dealing with many numbers in two Columns.

I have two sheets one of them is Sheet1 other one is Sheet2

Both of them have two columns. Columns A contains "Materialnumber" and Column B contains "Status". Sheet1 has more "Materialnumbers" inside then Sheet2
but Sheet2 includes correct "Status", so thatswhy if "Materialnumbers" are matching i would like to have the "Status" value of Sheet2 in Sheet1's Column C.

I know i should write the vlookup code in Sheet1's Column C. But what is the right formula for this?

Thanks in advance.