If(Iserror)

[dilip.7kumar]

Dear Friends,

Below is my excel data. What I want in column B is the Position of "IN" in cell number A1, Position of "FROM" in A2 and Position of "From" in cell A3.
In the data in column "A", "IN","FROM" & "From" will not come together, i.e. where there is IN there will be no From and FROM and so on. Is it possible that
the syntaxes given is column C can be combined using IF(Iserror) type of formula so that the formula gives the position of IN wherever there is IN, FROM wherever there is FROM and From wherever there is From.

A B C D
1. DEPO EMPTY STORAGE FOR 20EM IN ATVIE 29 =FIND("IN",A2,1) Want to combine these three formulaes
2. LOCAL EMPTY DV40EM FROM ATVIE TO ATVIE BY TRUCK 20 =FIND("FROM",A3,1)
3. TRANSPORT EMPTY HC40EM From BEANR To BEWLB by Barge 24 =FIND("From",A4,1)

[arlu1201]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.