how to show a list of words by typing a few letters

[chrisbmo2000]

For my invoice i am using a inventory page so all i have to do is type in the
part number and it lists a description and price.......can i make excel show
a list of part #s and description with out disturbing the vlookup formula
already in place?

 

[Gord Dibben]

You can use a Data Validation Dropdown list to pick your part number from and a
VLOOKUP formula to bring back the description.

DV dropdowns do not have the autocomplete feature.

You would have to use a combobox for that.

See Debra Dalgeish's site for help on DV and VLOOKUP.

Note the downloadable sample workbooks.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

For the combobox solution see

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

 

[chrisbmo2000]

thats not exactly what I was looking for but ill give it a shot though I may
have to split info accross cells but was hoping i didnt have to go that way

 

[Gord Dibben]

I assumed.......there's that word again.........that your data was in separate
cells.

Part# Description Price

If you have double data in cells you may have to split it out.


Gord Dibben MS Excel MVP