Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
VBLookup 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.newusers
|
|||
|
|||
VBLookup help
#NA! error means that the value in C44 does not match any entry in A2:A126 on
the Activity Codes sheet. If you are trying to match "WSC021" to "WSC021, WSI221" it simply will not work. It's not your formula that is the problem, it is the data table that will need changes. "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.newusers
|
|||
|
|||
VBLookup help
Thanks for the response. Codes and descriptios does exist which I am trying
to populate through VLOOKUP. Could you please specify bit more what do I need to change or investigate. Thanks Syed "JLatham" wrote: #NA! error means that the value in C44 does not match any entry in A2:A126 on the Activity Codes sheet. If you are trying to match "WSC021" to "WSC021, WSI221" it simply will not work. It's not your formula that is the problem, it is the data table that will need changes. "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 | |
|
|