Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBLookup - need help
Hello
I my spreadsheet I have three columns; Task Activity Codes Description Each task have a corresponding activity code with its description. I am using VLOOKUP to populate corresponding description for the activity code numbers in the master worksheet. Here is an example; =VLOOKUP(C44,'Activity Codes'!$A$2:$B$126,2,0) Task Activity Code Description Sample Station WSC021 Repair Water Valve In some cases I have multiple activity codes for a single task like Task Activity Code Description Sample Station WSC021, WSI221 Ideally it should populate multiple descriptions with the comma but I am getting #N/A. I am not sure what should I change in the formula to have this done. Any help or suggestion would be highly appreciated, thanks Syed |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBLookup - need help
Vlookup will result #N/A in the below cases.
When the lookup value is not present in Lookup Range and sometime there may be some extra space will be there in lookup value or in lookup range 1st column value which will result vlookup to return #N/A due to lookup data mismatch. So check the above with your data and lookup range. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Syed Rizvi" wrote: Hello I my spreadsheet I have three columns; Task Activity Codes Description Each task have a corresponding activity code with its description. I am using VLOOKUP to populate corresponding description for the activity code numbers in the master worksheet. Here is an example; =VLOOKUP(C44,'Activity Codes'!$A$2:$B$126,2,0) Task Activity Code Description Sample Station WSC021 Repair Water Valve In some cases I have multiple activity codes for a single task like Task Activity Code Description Sample Station WSC021, WSI221 Ideally it should populate multiple descriptions with the comma but I am getting #N/A. I am not sure what should I change in the formula to have this done. Any help or suggestion would be highly appreciated, thanks Syed |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBLookup - need help
Thanks for your response. As I mentioned, formula works fine if I have only
one activity code value in a column. However, #N/A appears as soon as I enter more then one activity code using comma. I am wondering if VLOOKUP can work with multiple values in a single row & column. "Ms-Exl-Learner" wrote: Vlookup will result #N/A in the below cases. When the lookup value is not present in Lookup Range and sometime there may be some extra space will be there in lookup value or in lookup range 1st column value which will result vlookup to return #N/A due to lookup data mismatch. So check the above with your data and lookup range. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Syed Rizvi" wrote: Hello I my spreadsheet I have three columns; Task Activity Codes Description Each task have a corresponding activity code with its description. I am using VLOOKUP to populate corresponding description for the activity code numbers in the master worksheet. Here is an example; =VLOOKUP(C44,'Activity Codes'!$A$2:$B$126,2,0) Task Activity Code Description Sample Station WSC021 Repair Water Valve In some cases I have multiple activity codes for a single task like Task Activity Code Description Sample Station WSC021, WSI221 Ideally it should populate multiple descriptions with the comma but I am getting #N/A. I am not sure what should I change in the formula to have this done. Any help or suggestion would be highly appreciated, thanks Syed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBLookup help | New Users to Excel |