This formula should stop the #NA appearing in the cells, I believe. I have used the =if(ISNA...... with indexes and matches without problem. However when I enter this particular formula I get an error message which highlights the "", indicating that I have entered them incorrectly. I tried a space between the "" and get the same error message. What am I doing wrong, or will the =if(ISNA..... not work in conjunction with a Vlookup? Thanks for any help.