Hi All,

I am using the Vlookup formula to compare two files daily extractions. The
#N/A value is retuned when there is correctly no match found. I want to
create a formula in a seperate column, based on the results of the Vlookup,
that would return a text string based on those results. IF statements work
great except for the #N/A results. I have tried IF(ISNA(cell
ref),"XYZ","ABC") and it still uses #N/A as a result of the IF. Any
suggestions would be greatly appreciated!
--
Linda