Should I be using vlookup?

[skidragon02]

I already am using the following formula in Column B:


=IF(ISERROR(VLOOKUP([@[RelRec From My List]],SherrysIVXlist,1,0)),[@[RelRec From My List]],"")


If this formula gives me a value in Column B, I want to take all of those given values and have them populate in a comma separated list. How should I write this formula?

 

[jason]

...i dont think a formula would be able to do this.....


but uploading a sample file would help the rest of us see and understand exactly what you're working with....

 

[Faseeh]

Hi skidragon02,


Please see this thread, it discusses a similar issue:


http://chandoo.org/forums/topic/concatenating-data-from-fields-with-more-than-one-duplicate-entry


Regards,