silverback24
Board Regular
- Joined
- Jul 30, 2013
- Messages
- 58
Hopefully the title isn't too confusing. Basically we are combining MPN's from our competitors for an upload to a repricer website. I have 3+ columns of vlookup results and would like for them to be combined like this (blahblah,blahblah,blahblah) while leaving out the cells with no results. I have tried the concatenate with isblank formulas for all blank cell options possible with no results. Obviously this will get out of hand when we have some with 6 competitors, if it even worked.
Is this macro territory or are there formulas that will handle this? I had kutools that would prob handle this but would have to purchase to use it.
Is this macro territory or are there formulas that will handle this? I had kutools that would prob handle this but would have to purchase to use it.