Prev: Macro to append number to file name
Next: HELP: Add textbox to a frame at run time
From: Syed Rizvi on 29 Jan 2010 14:43
Hello
In 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

From: Noe on 29 Jan 2010 17:11
Noe
Can you send an examlpe of the information you have?

"Syed Rizvi" wrote:

> Hello
> In 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
>
 | 
Pages: 1
Prev: Macro to append number to file name
Next: HELP: Add textbox to a frame at run time