0

I have a mapping sheet and would like to use VBA to look up certain portfolio.

The design goes like:

  1. Identify which portfolio to lookup
  2. vlookup the value on Data Input

Is it the right thinking? But, I don't know how to connect my point 1 and point 2 on excel VBA. Please kindly advise,

Portfolio Data Input Data Output
S1 Apple APPL
S1 Microsoft MSFT
S1 Walmart WMT
S1 Tesla TSLA
S1 Facebook FB
S2 Johnson & Johnson JNJ
S2 Tesla TSLA
S2 Fiverr FVRR
S2 Apple APPL
S3 Spot 1,700
S3 Beyond Meat BYND
S3 Dropbox DBX
S3 Tesla TSLA
S3 Apple APPL
FlyingTIger
  • 1
  • for formula: https://stackoverflow.com/questions/42492758/vlookup-using-2-columns-to-reference-another – Scott Craner Aug 05 '21 at 22:23
  • Please provide what have you tried and where you're facing issue in the code that you tried. Also it looks like your problem could also be solved using a formula. Please specify why did you decide to go with VBA. Refer to the following link: https://stackoverflow.com/help/how-to-ask – Gangula Aug 06 '21 at 08:44

0 Answers0