If Offset Index Match Returns Non-Numeric Value, Return Second Index Match

[ERLoft]

Need help with the last part of this formula please. The original formula worked great until I realized that the imported data had a duplicate value in a row that I'm wanting to ignore. Correct values have a numeric value in column 1 of the data range, so if the formula encounters a non-numeric value there, I want the formula to return the second instance of the result.

Here's the formula I have thus far:

=IFERROR(IF(ISNUMBER(INDEX(DCData,MATCH($A281,DCCD,0),1)),INDEX(DCData,MATCH($A281,DCCD,0),3),"Not Number"),0)

DCData Refers to $A:$Z on an import sheet, while DCCD Refers to $B:$B on the same import sheet. This formula does fine in up until the portion that shows as "Not Number". In here, I need help with the portion of the formula that will return the second match of $A281, DCCD,0.

Any help would be greatly appreciated. I feel like I should have figured this out, but am battling a cold and feel a bit out of whack.
Eric

 

[Special-K99]

Shouldn't this just be

=IFERROR(INDEX(DCData,MATCH($A281,DCCD,0),IF(ISNUMBER(INDEX(DCData,MATCH($A281,DCCD,0),1)),1,3)),0)

ie if column 1 is a number use column 1 else use column 3

 

[ERLoft]

I didn't try that to see if it would work, as upon closer review, the imported data, which is from a .txt file, had the error value as part of the header on each page - and there were nine pages. So I ended up using VBA to clear out all the values that didn't have a sequence number next to them.