MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo Box & Vlookup


Posted by Aaron on July 31, 2001 11:19 AM

Is it possible to have your lookup value in a vlookup to look at a Combo Box. If so then how? thx


Posted by steve w on July 31, 2001 9:12 PM

How about trying data validation or
just use the linked cell of the combobox as the lookup value for vlookup.

steve w

Posted by steve w on July 31, 2001 10:38 PM

I meant two ways

Posted by Becky on August 01, 2001 12:24 AM

Re: Aaron or Steve

How do you do this because this is what I want to do as well?

Posted by steve w on August 01, 2001 9:09 AM

Re: Aaron or Steve

put a combobox on the sheet set the fillrange then set the linked cell. The linked cell is the choice that is picked from the list. Then use vlookup and refer the lookup value to that cell.
If you still need help how about you post your email address and I will send you an example workbook.
steve w