Software

Ask something
Discussion Locked

Excel Data Entry

0 helpful
5 replies

by jimmy b.

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to ease data entry in an Excel spreadsheet by typing a character (letter or number) that corresponds with a line of text. I know Excel can handle this (via LOOKUP, maybe?), but I need some assistance. Is there any out there?

5 replies

by dklippert

There are a couple ways to do this. One is the VLOOKUP function. This function looks up the contents of a cell (Lookup_value) and compares it to the leftmost column of a table (table_array) and then returns the value in a selected column (col_index). If you want an exact match, use FALSE for the range_lookup parameter.

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
The table can be located on another worksheet and can be referred to by name.

Another way is to create an input box using the Form Toolbar. Check the Help file for details.
Let me know if you need more information.

by aisling

You could use a list box from the Data; Validation menu when the cursor is on the cell. In the Allow box put List, in the Source box put the location of your list of possible entries. When the user is on the cell a drop down arrow appears beside it and the user can chose their entry.

This discussion is closed to new replies.