IF Function

[MonsieurExcel]

Hi there,

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

Item Id PFLX050S2050BKF PFLX060S2050 PFLX060S2050/P1 PFLX060S2050BKF PFLX080S2050 PFLX030CE1000 PFLX030FH1000 PFLX030S1000 PFLX060S2050BKF PFLX020S2050 PFLX030FH2050 PFLX030S1220 PFLX030S1250 PFLX080S2000H/C PFLX080S2050 PFLX100S2000H/C <TBODY> </TBODY><COLGROUP><COL></COLGROUP>

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

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

 

[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.