Excel 2007 : Drop Down box with autocomplete on cells

**MARIANA** · 01-19-2012, 07:16 PM

I WAS ABLE TO CREATE A DROPDOWN BOX FOR PART# IN OUR INVENTORY. WHAT I'M TRYING TO ACHIEVE IS AFTER CHOOSING THE PART# I WOULD LIKE FOR THE DISTRIBUTOR NAME AND THE COST PER EACH ITEM TO AUTOFILL AFTER CHOOSING THE PART#. I HOPE I MADE SENSE, AND HOPE SOMEONE COULD HELP ME

I HAVE ATTACHED A COPY OF MY SPREADSHEET IF IT HELPS ANYONE TO HELP ME OUT...LOL

PARTS#.xlsx

**royUK** · 01-20-2012, 03:32 AM

That's simply done using VLOOKUP, see the example here

You don't appear to have a column for supplier

You don't need to type questions in Upper Case

**MARIANA** · 01-20-2012, 10:45 AM

I'm sorry I didn't mean to write in all Upper case, from my spreadsheet i have attached is there anyway you could provide me with example; i'm not to experience with excel and I really didn't understand the instructions on how to use a VLOOKUP

**royUK** · 01-20-2012, 12:54 PM

As I said before there is no column for Supplier.

You have a ComboBox on one sheet, and Data Validation lits on the other. Which do you want to use?

**MARIANA** · 01-23-2012, 12:06 PM

you are correct there is no column for supplier, i was just told we don't need to add this to the spreadsheet. I was playing around with the sheet, i need to use the data validation list, the combo box will be deleted.