Issue with VLOOKUP in Excel UserForm

[smha]

Hi

I've created a UserForm in Excel where I want 3 columns to be auto-filled alongside the data entered on the form (see image):
convolog.png

I've written the following code to achieve this, but the VLOOKUP keeps pulling the data from the first line of the table, not the data that corresponds to the lookup value (in this case a person's name, as I've demonstrated in the image):

Please Login or Register  to view this content.

Any help would be appreciated! This is my first time using VBA so keep it simple if possible please!

[xlnitwit]

Hi,

Please edit your post to include code tags, per the forum rules.

Then, is the data on the source sheet sorted in alphabetical order on column A? It must be for you to be able to use True as the 4th argument for VLookup- in all honestly I would expect False when matching names. It would also be more efficient to use Match to locate the row position and then simply refer to the cells directly.

[smha]

Hi

Thanks for your reply. I've edited my post as requested.

It would also be more efficient to use Match to locate the row position and then simply refer to the cells directly.

In terms of the above suggestion, how would this work in practical terms? Like I mentioned in my first post I'm a novice at this so I'm not sure how to use the Match function in this context!

Thanks again

[xlnitwit]

It would look something like this

Please Login or Register  to view this content.

[smha]

Thanks for all your help, it's working great now

[xlnitwit]

You're welcome.