I am a novice so please excuse this simple question.
I have two seperate worksheets that will carry the same data (Member Name and Member ID). The first worksheet will have both of these columns filled. But on the second worksheet, when the user types in the members name, i would like their corresponding ID from the original worksheet to automatically appear in the colmn next to the name. Is this possible?