i'm not sure i'm using the right formula, but i just can't get this to work with VLookup:
I have a doc1 with 599 names in column A. Some of them need to appear more than once. So you'd have the same name John in A1, A2 and A3.
I then inserted a column B with the same names, but only once, followed by column D, with their addresses. (columns D and E have additional information and also 599 records)
Now I need to make columns B and D also repeat the names and addresses. (or else the info in columns D and E won't match)
Basically, I want to look a value in A1, then compare it with column B and if it finds a match, insert it in C1.
any help appreciated.
C
I have a doc1 with 599 names in column A. Some of them need to appear more than once. So you'd have the same name John in A1, A2 and A3.
I then inserted a column B with the same names, but only once, followed by column D, with their addresses. (columns D and E have additional information and also 599 records)
Now I need to make columns B and D also repeat the names and addresses. (or else the info in columns D and E won't match)
Basically, I want to look a value in A1, then compare it with column B and if it finds a match, insert it in C1.
any help appreciated.
C