CODEWITHSUNDEEP
excel
Ammad
Ammad

Reputation: 4225

How to populate or update column value in an excel sheet based on data values in another reference column

I have two excel sheets: One have basic set of data as shown below. It have only three rows of data.

enter image description here

Now, my second sheet have 7 rows of data as shown below, but first column is empty.

enter image description here

Now, I want to update the first column of my second sheet using reference data of first sheet as shown below. I searched and used concatenation function but it is not working.

To make it simple, we can assume that both of the data sets are available on single sheet but under different columns. Wondering how to update the first column value? enter image description here

Edit: Complete set of data with column name: enter image description here

Upvotes: 0

Views: 1101

Answers (1)

James L.
James L.

Reputation: 9453

If the first sheet is Sheet1 and your second sheet is Sheet2, and all of our data is in columns A and B on the two sheets, then you can use a formula like this in Sheet2 (adjust B1 to match the row you enter the formula into):

=VLOOKUP(B1,Sheet1!A:B,2,FALSE)
          | \--------/ |   \------- find an exact match
          |      |     \----------- return the value from the 2nd column of the array
          |      \----------------- find the value in the first column of this array
          \------------------------ value to find

This takes the value aajain in cell B1 on Sheet2 and find the value in the first column (A) on Sheet1, and returns the second column (2) value. Using False in the formula tells it to use an exact match instead of an approximate match.

Upvotes: 1

Related Questions