Using the "IF" function to get certain information

[cgreen]

I'm brain dead today and need some help with an if formula.

I would like for the formula to do the following:
There will be several digits in cell "I2".
If the first 4 digits in cell "I2" is "1109" then put "nozzle-700" in cell "G2"; If the first 4 digits in cell "I2" is "1509" then put "nozzle-701" in cell "G2"; If the first 4 digits in cell "I2" is "1809" then put "nozzle-701c" in cell "G2";
If the first 4 digits in cell "I2" is "140b" then put "nozzle-401" in cell "G2";
If the first 4 digits in cell "I2" is "170b" then put "nozzle-401c" in cell "G2"; If the first 4 digits in cell "I2" is "1301" then put "nozzle-t55" in cell "G2"; If the first 4 digits in cell "I2" is "321-" then put "nozzle-t53" in cell "G2".

Are there to many arguments for this formula to work??

 

[Von Pookie]

If you set up a table, you can do this easily:

Book1
	A	B	C	D	E	F	G	H	I
1	1109	nozzle-700
2	1509	nozzle-701					nozzle-401c		170b4567
3	1809	nozzle-701c
4	140b	nozzle-401
5	170b	nozzle-401c
6	1301	nozzle-t55
7	321-	nozzle-t53
Sheet1

In this example, the table is in A1:B7. Then the formula in G2 takes the first 4 characters in I2 and searches for that in column A. If it is found, it will return the value in column B for that number.

 

[Pekkavee]

Better us VLOOKUP an LEFT formulas.

Pekka