Auto predict values in a column

[excel_2009]

hi excel gurus,

I was wondering if someone could help me with the following,

i have the following worksheet:
col A| col B
Magazine | Batman
DVD|Spiderman
Video| Superman
Poster|Wonderwoman

A user enters a comic character but i want it possible so that if a user types in "bat" or even "b" then it'll fill in the cell with batman, some sort of v lookup? from another sheet containing a list of all the characters

is that possible?

thank you!

 

[excel_2009]

click the excel button in the top left hand corner of the spreadsheet as though you were going to print then select options from the bottom of the page,


this option does not auto fill as you type it completes the word when you leave the cell

hi dryver,

i gave that a go but it seems manually intensive, i was hoping on the lines of a vlookup of somesort if possible or something along those lines

 

[excel_2009]

I have an add-in that does this, if you're comfortable with that approach.

There's an example workbook that uses it at http://www.box.net/shared/e8dbbple34.

If you like it, there's a ReadMe at http://www.box.net/shared/4qxybepxxr, and the add-in itself is at http://www.box.net/shared/ono8ni9xvr

HI shg,

unfortunately that is the issue i have, the drop down list is too manual intensive as there are loads of rows

 

[Dryver14]

If the letters arent too different then just place the list of names at the top of the column then when they start to type then name it should suggest the word anyway

 

[excel_2009]

If the letters arent too different then just place the list of names at the top of the column then when they start to type then name it should suggest the word anyway

Dryver, that's the closest i'll get to doing it, its case sensitive though but this seems the only option available, i hope thats not the case

 

[excel_2009]

anyone

 

[Dryver14]

If you know all the names then you could construct a vlookup table in which you could put the first letters both in caps and non caps and then when the person types the first letter or letters it would fill the name

eg

Col 1
s
S
SP
sp
spi
SP

Any of these inputs could generate spiderman in column 2 however this would require another column on the input chart one for inputting the value the other to show the word