VBLookup - need help

[Syed Rizvi]

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

 

[Ms-Exl-Learner]

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!

 

[Syed Rizvi]

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.