Populate worksheet based on VBA instead of VLOOKUP

[cterjesen]

I have a table of data that has common identifiers with another worksheet. I would like to use VBA to populate the other worksheet based on whatever identifier the user enters. I would like to do this instead of vlookups because the file is getting too large.

Does anyone have an example of this in a worksheet that I could download?

Thanks

 

[chicagocomputerclasses]

If your issue is that the file is getting too large I would strongly suggest using Power Query for this.
https://www.microsoft.com/en-us/download/details.aspx?id=39379

Convert the initial 2 datasets you have to tables and simply use merge with Power Query. Any time you want to refresh your data you'll just click refresh on your data model.