I've read about COUNTIF and it gave me an idea. Would it be possible to include COUNTIF into the formula to block it from finding values for the reference that is already there, in the main sheet?
What I mean is: You type in the reference, you get your values for it, later on you are mistaken and input the same reference number, but values show "Duplicate" or something now.
What do You guys think ?