CODEWITHSUNDEEP
excelvlookup
Bartu Saner
Bartu Saner

Reputation: 23

updating a worksheet with another sheets values

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.

Upvotes: 0

Views: 38

Answers (2)

Jordan
Jordan

Reputation: 4514

Try this in cell C2 on Sheet1:

=VLOOKUP($A2,Sheet2!A:B,2,0)

Upvotes: 0

Darren Bartrup-Cook
Darren Bartrup-Cook

Reputation: 19837

You're right - just a VLOOKUP needed in column C. In C2 put this formula:

=VLOOKUP($A2,Sheet2!$A$1:$B$12,2,FALSE)

  • It looks at the value in Sheet1 A2.
  • Compares that value against the first column in the range $A$1:$B$12 (update the range as required).
  • Returns the value from the second column (B).
  • Only returns on an exact match (FALSE).

Upvotes: 1

Related Questions