Correct my formula please

[srizki]

=IF(ISNA(INDEX(E5:E455,MATCH(A5,D5:D455,0))))

thanks

 

[Oaktree]

What do you want this to return?

You don't have the second or third arguments of your IF formula filled in...

 

[srizki]

I am comparing two columns, but I do not want #N/A error, that produces if value is not found, the main thing I want to learn is how can I avoid #N/A error using Match function.
I am using this =INDEX($F$2:F$454,MATCH($A519,$E$2:$E$454,0))
and this gives me the error, but when I use this
=IF(ISNA(VLOOKUP($D66,$A$4:$B$95,2,0)),0,(VLOOKUP($D66,$A$4:$B$95,2,0)))
that is fine, I just like to know how can I avoid #N/A error.
Thanks Oaktree.

 

[Seti]

Maybe this?

=IF(ISNA(MATCH($A519,$E$2:$E$454,0)),0,INDEX($F$2:F$454,MATCH($A519,$E$2:$E$454,0)))

 

[srizki]

Yes Seti, I worked, I learned something new today.
thanks to both of you. and thank to MR. EXCEL

 

[srizki]

Question: why there is no "0" in both of those Match functions.
thanks

 

[srizki]

In fact it does not even accept zero. why is that.?

 

[Oaktree]

Question: why there is no "0" in both of those Match functions.
thanks

Isn't there?

In Seti's formula...
=IF(ISNA(MATCH($A519,$E$2:$E$454,0)),0,INDEX($F$2:F$454,MATCH($A519,$E$2:$E$454,0)))

 

[srizki]

Sorry Oaktree, I did not see that.

 

[srizki]

Sorry Oaktree, I forgot to put zero in my formula.
thanks