Welcome to the Forum gunsafety !
It's usually better to describe your problem rather than suggesting how you expect to solve it. This does not sound like a data validation problem to me. How do you want to determine the member number? Do you type in a name and need to retrieve the member number? If your two columns of data are in A and B, and you type a member name in C1, this gives you the member number:
If that's not what you mean, then please give a more detailed description of how the data is organized in your file, what input the user will provide and where, and what you want the output to look like and where.
The best thing would be to attach a file with no private data. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Bookmarks