Transfer Data Between Worksheets

Re: Transfering Data Between Worksheets

I think the function [vl]*[/vl] is what you want to use. Hit Shift-F3 simultaneously in the cell to bring up the Insert Function box. Put in Vlookup in the Search box, then, after you've found it in the list, click on the link "help on this function." If that's not what you want, write back.

Quote from BrianNC

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?

Thanks,
Brian