Find using IF
 

Hi,

I have all the product names in Column A, i want to search for a particular
value in that list using, IF condition something...
=IF(A1:A10="ProdA","Found","Not Found")

I know, look up formulas will help me, but is it possible to do it using IF
probably as a array ?

--

Thanks
Sri

Find using IF
 

So ProdA can appear in any of those cells (any one or all 10?)

=if(countif(a1:a10,"proda")0,"Found","not found")



Sri wrote:

Hi,

I have all the product names in Column A, i want to search for a particular
value in that list using, IF condition something...
=IF(A1:A10="ProdA","Found","Not Found")

I know, look up formulas will help me, but is it possible to do it using IF
probably as a array ?

--

Thanks
Sri

--

Dave Peterson

Find using IF
 

=IF(ISNUMBER(MATCH("ProdA",A1:A10,0)),"Found","Not Found")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sri" wrote in message
...
Hi,

I have all the product names in Column A, i want to search for a
particular
value in that list using, IF condition something...
=IF(A1:A10="ProdA","Found","Not Found")

I know, look up formulas will help me, but is it possible to do it using
IF
probably as a array ?

--

Thanks
Sri

Find using IF
 

=IF(countif(A1:A10,"=ProdA")0,"Found","Not Found")

--
HTH...

Jim Thomlinson


"Sri" wrote:

Hi,

I have all the product names in Column A, i want to search for a particular
value in that list using, IF condition something...
=IF(A1:A10="ProdA","Found","Not Found")

I know, look up formulas will help me, but is it possible to do it using IF
probably as a array ?

--

Thanks
Sri