Search results

Thanks Asa. It's actually ISERROR rather than ISNA, but it seems to work. :-)

No. The ".000" is part of a reference, it's not a number. In column A I have a list of reference nos in the format, say, "A143.001", which are like headings for dates beneath. In column G I have just a list of reference nos, the same type of reference as in column A, but with an extra ".000"...

Column G contains another list of reference nos, but not the complete list that's in column A, and also with another ".000" on the end of each, hence comparing only the first 8 digits. The formula is looking for the reference no and then the cells beneath it, hence the +8 in this particular...

I have a list of reference nos and under each reference no a list of dates applicable to that reference. The formula is taking the dates out and adding them to another list, ignoring any cells that contain the reference nos.

=IF(AND(INDEX($A:$A,MATCH(LEFT($G8,8),$A:$A,0)+8)<>"????.???",W8<>""),INDEX($A:$A,MATCH(LEFT($G8,8),$A:$A,0)+8),"")

Hi I'm trying to put together a formula which returns the value of a cell unless the cell contains a string of characters which will always be in the same format - X000.000. I'm finding the cell I require by using MATCH and getting the content of the cell using INDEX. I'm getting the correct...