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.