Multiply Formula Based Off Several Texts

[Treesh1994]

What I am looking to do is have an autofill on A18 on down based on the number of vehicles from AT1. In this example I chose 6. I prefilled the information in on column A QTY section.

The High lighted words on H26, H30, H31 needs to have a total of 2 per vehicle. The rest of the lines in column H needs to be 1 per vehicle.

The words in H26, H30, H31 may be moved throughout the document so I want a formula that it doesn't matter where it is on the page. If the word ELUC3H010D, EMPS1STS4RBW, or EMPS2QMS5RBW shows up in the document, I want excel to know it needs to be multiplied by 2, and the rest by 1.


I hope this makes sense and someone can help me make a formula!

EDIT:
Also I forgot to mention, that I don't want to use VBA if at all possible

 

[Treesh1994]

Like this then?

Treesh1994.xlsm
	A						G	H	I	J	K																																			AT
1																																														6
17
18	6							a
19	12							ELUC3H010D
20
21	-6							99B
22	12							EMPS2QMS5RBW
Sheet1

Cell Formulas
Range	Formula
A18:A22	A18	=IF(H18="","",IF(H18="99B",-AT$1,AT$1*(1+OR(H18={"ELUC3H010D","EMPS1STS4RBW","EMPS2QMS5RBW"}))))

Yes that is exactly what I am looking for!

Thank you so much for your help!

I greatly appreciate your assistance on this!

 

[Peter_SSs]

You're welcome. Glad we got there in the end. Thanks for the follow-up.

(But please look into XL2BB for any future questions. )