IF Function

[MonsieurExcel]

Hi there,

My question is related to the following (shortened) table:

[TABLE="width: 104"]
<TBODY>[TR]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 235"]
<TBODY>[TR]
[TD]Item Id[/TD]
[/TR]
[TR]
[TD]PFLX050S2050BKF[/TD]
[/TR]
[TR]
[TD]PFLX060S2050[/TD]
[/TR]
[TR]
[TD]PFLX060S2050/P1[/TD]
[/TR]
[TR]
[TD]PFLX060S2050BKF[/TD]
[/TR]
[TR]
[TD]PFLX080S2050[/TD]
[/TR]
[TR]
[TD]PFLX030CE1000[/TD]
[/TR]
[TR]
[TD]PFLX030FH1000[/TD]
[/TR]
[TR]
[TD]PFLX030S1000[/TD]
[/TR]
[TR]
[TD]PFLX060S2050BKF[/TD]
[/TR]
[TR]
[TD]PFLX020S2050[/TD]
[/TR]
[TR]
[TD]PFLX030FH2050[/TD]
[/TR]
[TR]
[TD]PFLX030S1220[/TD]
[/TR]
[TR]
[TD]PFLX030S1250[/TD]
[/TR]
[TR]
[TD]PFLX080S2000H/C[/TD]
[/TR]
[TR]
[TD]PFLX080S2050[/TD]
[/TR]
[TR]
[TD]PFLX100S2000H/C[/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]What I need to do is say something along the lines of...."if Item ID contains 2050 then "large", if it contains 2000 then "medium" etc....

I hope that's clear enough - if not driop me a line and I'll clarify.

Thanks a lot

[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]

 

[Peter_SSs]

The description "etc" is a bit vague, but see if this helps get you going. Formula copied down.

Excel Workbook
	A	B
1	Item Id	Size
2	PFLX050S2050BKF	large
3	PFLX060S2050	large
4	PFLX060S2050/P1	large
5	PFLX060S2050BKF	large
6	PFLX080S2050	large
7	PFLX030CE1000	small
8	PFLX030FH1000	small
9	PFLX030S1000	small
10	PFLX060S2050BKF	large
11	PFLX020S2050	large
12	PFLX030FH2050	large
13	PFLX030S1220	unknown
14	PFLX030S1250	unknown
15	PFLX080S2000H/C	medium
16	PFLX080S2050	large
17	PFLX100S2000H/C	medium
ID Size

 

[Chantty]

try this:-

=IF(ISERR(FIND("2050",A2)),IF(ISERR(FIND("2000",A2)),"","Medium"),"Large")

 

[MonsieurExcel]

Thanks very much Peter and Chantty!! Both work very well for me.