Discussion Locked

Comboboxes and Excel: Autofilling a form

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

A company that I recently started to work for wants to make a Excel (or MS Access) sheet that, when provided with a part number in a combo box or list, will automatically fill in three out of eight cells directly related to that information (specifically, model #, OEM, and the already selected part number.) There are five cells in the row that will need to have the data entered manually, as it is not dependent on the part number.

My experience with excel is limited to only data entry functions, and I have spent most of my free time reading the help files and such to find a way to do this. Alas, I am completely lost and must admit that I cannot do this on my own.

Anyone interested in helping may email me at any time for more information.

3 replies

by dklippert

Check the Help file for VLOOKUP.

It's a function that will look up corresponding values based on an initial entry.

Construct a table with the information.
Part number, Model, OEM etc.

If the part number is entered in cell A10, and the table occupies a range of say D2:G100, the function would display the pertinent value:
VLOOKUP(lookup_value,table,column,lookup)

=VLOOKUP(A10,D2:G100,2,FALSE)
Would show the value in the 2nd column.
The table should be sorted in part number order. FALSE means that it will only show an exact match.
Use a similar function in the other cells.

This discussion is closed to new replies.