Hi,

Yes, I tried everything: taking out "On error resume next" and the 2 codes you posted. The code doesn't give any kind of error per se. The problem is that when the value I'm looking for (from book1) doesn't appear in book2 it returns T+1. What i would like the code to do is if the value is not found in book2 leave the cell in book1 untouched.

In book1 i have some ISINs with relevant info that is taking from book2 (which is the main database). The problem is that some of these ISINs don't appear in book2 so the data I need to fill in I just look it up in other sources and type it in book1. But when I run the macro, these data that I typed in because it wasn't in book2 just gets overwritten (when it shouldn't get overwritten because it doesn't appear in book2). I feel it's a mess of explanation, but if you need more info or I didn't make myself clear let me know please.

Ps. I don't know if it could be this, but problem only occurs when the code has more than one vlookup function

Thanks again!