#1
|
|||
|
|||
Vlookup help
Hello, I am new to excel and any help would be greatly appreciated. I have 2 sheets with 2 columns each. First column in sheet 1 is a name, and second column is an ID number. Second sheet is also a name, and ID numbers. I need the ID numbers that are on sheet 1 copied to sheet 2 if the names are on both lists. How can I go about doing this? |
#2
|
|||
|
|||
Can you post an example workbook? I will be several million times eaiser to show you
|
#3
|
|||
|
|||
Assuming that the first list is in sheet 1 with names in col A and ID in col B, and the same in sheet 2 for the 2nd list,
then to "=VLOOKUP(A2;Sheet1!A:B;2;0)" will return the ID in sheet 1 of the name in cell A2 of sheet 2. You need to put a 0 as the 4th parameter to force an exact match. If there are 2 identical names in sheet 1, the formula will return the first one. If a name is not found, it will return NA# that you'll need to deal with. I searched the whole column, but you may want to use a named range or dynamic range to restrict the search, but I don't think that it does make much difference performance wise. see attached example. |
#4
|
||||
|
||||
Quote:
Or simply use the Excel Table feature |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Tell me which place the vlookup was successful (within a nested vlookup) | Izzii0x | Excel | 2 | 07-18-2019 10:29 PM |
How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array | EcommDOC | Excel | 7 | 01-22-2018 11:00 AM |
Vlookup | Missthingy | Excel | 1 | 02-10-2017 09:59 AM |
IF and VLOOKUP | SBMC | Excel | 1 | 11-07-2012 10:24 AM |
Vlookup | ibrahimaa | Excel | 8 | 01-03-2012 09:32 PM |