A little lost on the if-then formula....

[ComeOnKip]

is there a way I can do an if-then by only searching for sections of text? I'm doing a pricing list and my IT guy won't allow me to seperate part specific suffixes from the root description. I'm trying to get one huge function to search for different sections of text and apply additional costs to a base cost. So say my part description is in cell b5 and says '6x6x6 GF WW 1F1E KC'... is there a way to do an if-then on just the 1f1e and kc to add a cost to the base price?

I'm sorry if I'm not using the correct vernacular, I'm moderately computer literate, but these advanced formulas make my head spin a bit

[Pepe Le Mokko]

OP not interested

[Solus Rankin]

Can you attach an example workbook?

Click the 'Go Advanced' button and then attach paperclip.

[ComeOnKip]

Ok, so i attached a small portion of the excel sheet i'm working with, but it should give a good idea of what i'm trying to explain.

Soooo, G1 is my base cost, and all the descriptions in Column B are indicative of a part and the options that come with said part. Now the suffix 'KC' will add 0.75 to the base cost of G1, and '1F1E' will add 0.38 to the base cost, so in turn, '1F1E KC' will add 1.13 to the base cost. Is there a way to make a if then formula for those fragments of text to add the appropriate base cost into the G column? Keep in mind I have about 40 of these suffix options I can work with, but I'd rather write one long *** formula I can cut and paste special then having to add up option costs for 15,000 some odd part numbers.

Sorry once again if my choice of words is off... kind of new to this Thanks in advance!

[ComeOnKip]

I am interested, I didn't even see your formula... sorry.

[Solus Rankin]

Attached is a solution. I don't know how comfortable you are with VBA (I don't even know how comfortable I am with VBA), but its going to take some work to add the addition part number options you said there might be. PM me if you need help adding them. Test this by pressing Control+n.

samplekb.xlsm


If you decide this solution is viable then please mark the thread as solved and add reputation by pressing the * below.

[FDibbins]

XeRo, please do not ask other members to PM you additional info. The whole purpose of the forum is for eberbody to help and learn from other members questions. If you get 1/2 the info in private, how will anybody else know what that info is?

[Solus Rankin]

Of course. My mistake. I was afraid it would be to much back and forth but that makes perfect sense.

[FDibbins]

Thanks for the understanding

ComeOnKip, see if the attached will get you heading in the right direction?

I used a series of helper columns for each "code", and added a bit extra in for those codes that "double up". You can hide these columns if you want, or put them wayyy off to the side where no1 can see them