=IF function?

[Amynmercedes]

Hi there,

I am trying to create an estimate tracker which would allow a user to select their estimator initials from the data validation-list in column C, which once selected would generate the quote number in the previous column B (rows 12 down). Catch is, I'm really new to this and I would like the quote number to generate in sequential order but have a the number differ based on the estimator, for eg:

[TABLE="width: 288"]
<tbody>[TR]
[TD][/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]280-AM-1984[/TD]
[TD]AM[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]280-BP-1985[/TD]
[TD]BP[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]280-AM-1986[/TD]
[TD]AM[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]280-GL-1987[/TD]
[TD]GL[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Hope that's a clear enough explanation. I think I need to use the =IF function but it's putting together how to use the True/False values and how to incorporate the column C data which stumps me. Any help would be greatly appreciated!

Many thanks

 

[jtakw]

Hi,

Not exactly sure if this is what you're asking:

You'll need to enter the FIRST quote number (B12) manually, then use the formula in B13 copied down.

Book1
	B	C
12	280-AM-1984	AM
13	280-BP-1985	BP
14	280-AM-1986	AM
15	280-GL-1987	GL
16	280-BP-1988	BP
17	280-BP-1989	BP
18	280-GL-1990	GL
19	280-AM-1991	AM
Sheet50

Cell Formulas
Range	Formula
B13	=LEFT(B12,3)&"-"&C13&"-"&RIGHT(B12,4)+1