MrExcel Publishing
Your One Stop for Excel Tips & Solutions

List box / combo box?

Posted by Lori on December 07, 2001 9:07 AM

This is probably so easy for you guys, but I don't understand: I have a list of Account numbers and their Descriptions in cells AA and AB. In each cell of column D, i want to be able to pick from a list of the Descriptions, and have Excel return the corresponding account number in the cell next to it. Any help with this? Thanks.

Posted by Hansoh on December 07, 2001 12:05 PM

sounds like a perfect application of the =vlookup() function. look in the Help section.