With the combo box from the Forms toolbox you can 'link' it to a cell so that
when you pick a value in the combo box, that value is placed into the linked
cell. You could then reference that cell in your VLookup formula.

Right-click on the combo box and choose [Format Control] and then use the
[Control] tab to set the address of the linked cell. You can probably
double-click on the combo box and have it pull up the [Format Control] dialog
also, if you have the Forms toolbox displayed when you double-click on it.

"KH" wrote:

I have many items to input into my selection list in my worksheet. Hence, I
came up with the Combo Box (from FORM under Toolbars) function.

In addition, based on the "answer" selected from the combo box, I need to
generate the other details based on this "answer".

Is it possible to incorporate my Combo Box selection "answer" as my
lookup_value in my Vlookup function. If yes, how do i proceed?

Thank you!