Vba - vlookup

[cmerrick]

I'm using a WorksheetFunction.Vlookup to pull info into a large user form. The information displayed changes based on the 'month' that is chosen on the user form.

I want to be able to amend this information and then send it back to the original cells it came from based on the month that's displayed on the userfom (so the most recently updated data).

I've sent data from user forms to work sheets before but not from a Vlookup function. Can anyone share any help on this?

 

[RickXL]

Hi,

Instead of VLOOKUP use MATCH instead.

MATCH will find the value that matches and will return its row number. You can then use that row number to read the data from the worksheet and write it back afterwards.


Regards,