Hello all,

I am working with the following cells

A B

HAC024GKC 2
HAC418GKC 4
HAC224GKC 16

I would like to write a funcition that looks at the first 4 integers of the
cells in Column a and performs an output based on those integers.

Example : If it starts with HAC0 then multiply 10 times the field adjacent
to the right

If it starts with HAC4 then multiply 30 time the adjacent field.

If it starts with HAC2 then multiply 20 times the adjacent field.

My thought were to use the "LEFT" function inside of a "LOOKUP" Function.
The reason I am using the lookup instead of an "IF" function is because I
will be looking at more than 7 values. I am getting all sorts of errors when
I try this.

Any ideas?