Hi,
Something like this..
=IF(ISNUMBER(SEARCH("FL",IR3)),IR3,IF(ISNUMBER(SEARCH("FL",IS3)),IS3,IF(ISNUMBER(SEARCH("FL",IT3)),IT3,IF(ISNUMBER(SEARCH("FL",IU3)),IU3,""))))
The above formula check from Cell IR3 to IU3, if any match is found from the
starting cell then it stops the the remaining conditions and get the cell
value.
Change the cell references to your desired cell, if required.
If you want to show "NO" when there is no matches found in the specified
cells then instead of blank "" change it as "No" like the below.
=IF(ISNUMBER(SEARCH("FL",IR3)),IR3,IF(ISNUMBER(SEARCH("FL",IS3)),IS3,IF(ISNUMBER(SEARCH("FL",IT3)),IT3,IF(ISNUMBER(SEARCH("FL",IU3)),IU3,"NO"))))
Hope that helps!
-----------------------
Ms.Exl.Learner
-----------------------
On Tue, Sep 27, 2011 at 11:11 PM, plus766 <pluss...@gmail.com> wrote:
> I have a spreadsheet where I've done an index match to return
> criteria. I have to match three or four columns to get the information
> that I need, so I have three or 4 columns that either have the
> information I need or a "NO" from the index match.
> I need a formula to look at the columns and say, if the value is in
> this column, return it, otherwise go to the next column, etc.
> also I have the formula
> IF(ISERROR(SEARCH("FL:",IR3)),"",IR3)
> but where the "FL:" is, may be "FL:ABC" or "FL:XYZ", with many
> combinations.
> so I need to match the 3 or 4 columns, and return the value that
> contains "FL:" with something else after it.
> I hope this makes sense.
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
