Hi.
I have two books, with an identifier-variable, where some are alike. Book 1 contains a complete list, while book 2 is a working book, where rows are gradually entered - again with each rower uniquely identified with this identifier-variable.
I have constructed, a VLOOKUP-function that in book 1, genreates a "yes-or-no" variable, indicating whether the ID is present in both work-books. I have also constructed it in a way, so that everytime i in book 2 enter a new row, it will automatically update this "yes-or-no"-variable in book 1.
My problem, however, is for this function to work, I need to have both book 1 and 2 open at the sime time - otherwise i get this "#reference"-problem. Since both books are relatively large, merging them is not really an option.
Is there anyway, I can work in one of the books without having both open? Obviously, if I want it to update the "yes-or-no"-column in book 1, I would need to open both, but isn't there some way that excel can just treat the column as "fixed" until it is automatically updated, when I open both books?
Thanks very much in advance. I have uploaded the books - however, I have the danish excel version - if it isn't understandable i will make a whole new book.
Regards Alexander
Bookmarks