I'm running Excel 2013 and I have one workbook with two sheets - sheet1 and sheet2. Sheet1 has 24 columns and 26K rows. Column "A" is titled "id" and contains
id numbers that are also, some, found in column "A" of Sheet2 - which is also titled "id".
Sheet1 has no "description" column. Sheet 2 only has 2 columns - "A" is the "id" column and "b" is the "description" column.
A B
ID Description
58749651 a bunch of text
How can I create a description column on sheet1 (it would be column "U") and populate it with the description from sheet2 only where the "id" values from column "A" match?
Thanks!
Rob
Hi Rob,
Utilize the VLOOKUP function and this should resolve it.
For example, in a new column on sheet 1 (Y) a formula like this should suffice assuming ID is in column A:
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
Or more elegant:
=IFERROR(VLOOKUP(A1,Sheet2!A:B,2,FALSE),"")
More information on VLOOKUP can be found here: VLOOKUP Function
- Proposed as answer by Robert McQuaig Thursday, January 29, 2015 7:25 PM
Hi Rob,
Utilize the VLOOKUP function and this should resolve it.
For example, in a new column on sheet 1 (Y) a formula like this should suffice assuming ID is in column A:
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
Or more elegant:
=IFERROR(VLOOKUP(A1,Sheet2!A:B,2,FALSE),"")
More information on VLOOKUP can be found here: VLOOKUP Function
- Proposed as answer by Robert McQuaig Thursday, January 29, 2015 7:25 PM
- Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 4 hours 6 minutes ago
Hi,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"
Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.
Thanks
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"