Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare value to range, return matched value
Need help.
I have three columns of data: Column A = Employee ID's Column C = Employee ID's Column D = System Name Column C contains all company Employee ID's and Column D contains the associated system name. I am taking certain sets of Employee ID's and putting them in Column A. I would like to compare each ID to the range of ID's in Column B and return the assigned system name from column D into Column B. Emp ID(1) Matched System Name Emp ID(2) System Name 5 Sys00005 1 Sys00001 6 Sys00006 2 Sys00002 7 Sys00007 3 Sys00003 4 Sys00004 5 Sys00005 6 Sys00006 7 Sys00007 I hope this outlines what I am looking for. The data put into column A can vary in array length but will never be larger than the data array in column C/D. I am sure this is easy for the experts but I have been cruising the discussion boards and can not find a prior discussed solution. The purpose for this is I need to search smaller sets of ID's across thousands of company ID's to get system names which I can copy pasted into another worksheet. Thanks! TKD |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare value to range, return matched value
Your example is somewhat disjointed in the message (not your fault but this
occurs). If I have assembled it correctly then you should be able to place the following formula in cell B2 (assuming that the columns headers are in row 1 and the first cell to lookup is cell B2). =VLOOKUP(A2,$C$1:$D$8,2) Copy the formula down in column B -- Regards, OssieMac "TKD" wrote: Need help. I have three columns of data: Column A = Employee ID's Column C = Employee ID's Column D = System Name Column C contains all company Employee ID's and Column D contains the associated system name. I am taking certain sets of Employee ID's and putting them in Column A. I would like to compare each ID to the range of ID's in Column B and return the assigned system name from column D into Column B. Emp ID(1) Matched System Name Emp ID(2) System Name 5 Sys00005 1 Sys00001 6 Sys00006 2 Sys00002 7 Sys00007 3 Sys00003 4 Sys00004 5 Sys00005 6 Sys00006 7 Sys00007 I hope this outlines what I am looking for. The data put into column A can vary in array length but will never be larger than the data array in column C/D. I am sure this is easy for the experts but I have been cruising the discussion boards and can not find a prior discussed solution. The purpose for this is I need to search smaller sets of ID's across thousands of company ID's to get system names which I can copy pasted into another worksheet. Thanks! TKD |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare value to range, return matched value
Thanks...I had tried that before, but kept getting NA error message....but I
found that if I used the TRIM function on my data being compared, and switched to exact match, it seems to work. Thanks! "OssieMac" wrote: Your example is somewhat disjointed in the message (not your fault but this occurs). If I have assembled it correctly then you should be able to place the following formula in cell B2 (assuming that the columns headers are in row 1 and the first cell to lookup is cell B2). =VLOOKUP(A2,$C$1:$D$8,2) Copy the formula down in column B -- Regards, OssieMac "TKD" wrote: Need help. I have three columns of data: Column A = Employee ID's Column C = Employee ID's Column D = System Name Column C contains all company Employee ID's and Column D contains the associated system name. I am taking certain sets of Employee ID's and putting them in Column A. I would like to compare each ID to the range of ID's in Column B and return the assigned system name from column D into Column B. Emp ID(1) Matched System Name Emp ID(2) System Name 5 Sys00005 1 Sys00001 6 Sys00006 2 Sys00002 7 Sys00007 3 Sys00003 4 Sys00004 5 Sys00005 6 Sys00006 7 Sys00007 I hope this outlines what I am looking for. The data put into column A can vary in array length but will never be larger than the data array in column C/D. I am sure this is easy for the experts but I have been cruising the discussion boards and can not find a prior discussed solution. The purpose for this is I need to search smaller sets of ID's across thousands of company ID's to get system names which I can copy pasted into another worksheet. Thanks! TKD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return matched value 2 criteria | Excel Worksheet Functions | |||
Excel - Compare spreadsheets and indicate matched data | Excel Worksheet Functions | |||
Return Matched Numeric Labels across Single Row | Excel Worksheet Functions | |||
Return Title to matched column | New Users to Excel | |||
How to compare 2 lists and return un-matched? | Excel Worksheet Functions |