Combo boxes

[mags74]

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.

 

[ravishankar]

Hi
from your message, it is not clear what you are looking up from where
Assuming you are looking for combo box choice in col a of data sheet and corresponding value in col b
Paste the following codes in the macro window ( Alt f8)

cells(1,2) = application.worksheetfunction.vlookup(cells(1,1), worksheets("data").range("A2:B100"),2,false)
msgbox " Value corresponding to " & cells(1,1) & "  is  " & cells(1,2)

run the macro
Ravi

 

[mags74]

is there a way to do this without having to run a macro and it just automatically updating the cell once a certain item is chosen from the combo box?

in the cell next to the combo box - would be where the vlookup results would be - but i would like to do the vlookup through visual basic so there are no formulas on the spreadsheet. the list for the vlookup are on a separate tab.