Find formula not calculating?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam - 17 Dec 2007 12:48 GMT

Hi All

I'm using Excel 2007 on Windows Vista.

I have a decription in column I like "S/back 2.0 TDI SE DSG " and in
column Q I have the formula FIND("DSG",$I2).

Looks simple enough to me but it isnt bringing the result I want! Just
an #VALUE! error value.

Can anyone see what I am doing wrong?

In column R I have FIND("multi",$I2) and thats working fine!!

Many Thanks!

Adam

Reply to this Message

JE McGimpsey - 17 Dec 2007 13:03 GMT

If your description is accurate (i.e., that $I2 contains "S/back 2.0 TDI
SE DSG "), then your formula in column R (FIND("multi",$I2) should
return #VALUE!, so are you sure that $I2 actually contains "DSG" ?

In article
<c63a53e6-d010-4c70-b6db-35cf4311c90e@18g2000hsf.googlegroups.com>,

> Hi All
>
[quoted text clipped - 13 lines]
>
> Adam

Reply to this Message

Adam - 17 Dec 2007 13:07 GMT

> If your description is accurate (i.e., that $I2 contains "S/back 2.0 TDI
> SE DSG "), then your formula in column R (FIND("multi",$I2) should
[quoted text clipped - 20 lines]
>
> > Adam

Correct, column R should return #VALUE! in this example and I should
read a number.

I have lots of descriptions so sometimes R returns a number but column
I isnt working.

Reply to this Message

JE McGimpsey - 17 Dec 2007 14:43 GMT

In article
<5bf49d3b-d233-4d07-b512-16f84368a286@d21g2000prf.googlegroups.com>,

> > If your description is accurate (i.e., that $I2 contains "S/back 2.0 TDI
> > SE DSG "), then your formula in column R (FIND("multi",$I2) should
[quoted text clipped - 26 lines]
> I have lots of descriptions so sometimes R returns a number but column
> I isnt working.

What do you mean by "column I isnt working"? Isn't column I your data
column?

BTW - whether you prefer Top posting or Bottom posting, it's generally
good netiquette to continue the style in the thread so that readers
don't have to sort out the top/bottom bounce.

Reply to this Message