Vehicle Configurations

[goatbrother70]

All,
First, thanks for the help, I greatly appreciate it. I have a fleet of vehicles that have various modifications to them. The modifications change from time to time and I would like to track the mods to each vehicle. The way I do it now is track every vehicle and put the proper suffixes on them then post the document.

I can do the =IF functions for one block, but when the vehicle has more than one modification I would like the result to show both characters in the "Overall" modifications block.

I have attached a sample of what I am talking about......please help.

Ken

Modification Example.xlsx

[azumi]

And what do you need to return as a results? Is that Column Header like Hemi, Radio... that has "X"?

Azumi

[goatbrother70]

I would like it to show the character below the mod. So for instance A654 has a Hemi mod, I would like it to return "A654@hp" Or A654 in one block and @hp in another block. I can import the table or link it to a report later.


Thanks for the help -- Ken

[sktneer]

If you are open to a VBA solution, try this code......

Please Login or Register  to view this content.

For detail see the attached sheet.