linking columns for auto fill-in

W

williamz

I'm very new at this - I want to simplify filling in a timesheet. I have one
column with text descriptions and an adjoining column with code numbers for
each description. I want to type in the first few letters of the description
and have auto fill-in generate the remainder of the text, AND, the
corresponding code number. This is my first post.
Thanks very much - williamz
 
G

Gord Dibben

If you have a contiguous range of cells in the description column and
Autocomplete enabled, the first few letters typed should give you the
choices.

For the adjoining column fill-in you could use a VLOOKUP formula and a
lookup table.

Assumes each same description has the same code number.

See help on VLOOKUP.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Formula required for matching cells 2
Using codes to input saved info into a cell? 1
Drop Down List & Auto Fill 2
Series fill only copying and fill series greyed out 1
Autofill data based on an assigned code/prefix 2
Auto fill Column based on data in other columns 1
Linking columns for auto fill 1

Top