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.
I posted this in a forum, but I have searched and cannot find it. Our
server went down at the same time, so I am not certain it posted.
Thank you
Plus766