How do you add a vlookup or index match through visual basic based on what is chosen from the combo box? I am sure this has already been asked and answered, but my search button is not working correctly. Sorry.
Also, I would like to do the vlookup or index match from a separate page that the results would go.
I have an "input" page with the combo box (A1) and the cell (B2) for the data for the vlookup is on a "data" page in the workbook.
Thank you all for your help in advance.
Also, I would like to do the vlookup or index match from a separate page that the results would go.
I have an "input" page with the combo box (A1) and the cell (B2) for the data for the vlookup is on a "data" page in the workbook.
Thank you all for your help in advance.