I am trying to write a formula that says If the Vlookup returns NA, then plus
a particular cell, otherwise return the vlookup value. Can this be done.
I've writen it as IF(isna(vlookup,etc.),+a1,(vlookup,etc)

Any Ideas as to why it dosen't work.