MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Transferring exact values from a worksheet to another


Posted by Mark on June 06, 2001 4:52 PM

Hi, I’m an Excel beginner so I guess this is pretty straight forward but I cannot find any reference.
I have two different worksheets A and B.
In Worksheet A I have a list of names in column A and a list of Yes in column B. Note that some of the cells in column B are blank. E.g.
Column A Column B
Thomas Yes
Mark Yes
John Yes
Henry
Tom Yes
Foster
Alan Yes
Anna Yes

In Worksheet B I have a list of names in column C. Some are the same as the ones in worksheet A, but they are in different order and mixed with other names. E.g.
Alan
Fred
Tom
Mick
Mark
Anna
Terry
Thomas
John
Foster

I would like to automatically import Column B from worksheet A into Worksheet B in a way that Yes appear automatically with the correspondent name. E.g.
Alan Yes
Fred
Tom Yes
Mick
Mark Yes
Anna Yes
Terry
Thomas Yes
John Yes
Foster

What should I do? THANK YOU!


Posted by Russell on June 06, 2001 4:58 PM

Use VLOOKUP. So let's say that the values in sheetA are in columns A and B, from rows 1 to 10. Let's say that the names in sheetB are in column C (like you said above), and also start in row 1:

In cell D1 type: =Vlookup(C1, Sheet1!$A$1:$B$10,2,FALSE)

Then pull the formula down.

Hope this helps,

Russell

Posted by Mark on June 06, 2001 5:34 PM

Thanks Russell,
I got it now!