Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Question
Hi Everyone,
Thanks for your continuos help and support. Wonder if anyone can help me: I am using the VLOOKUP formula. It works ok, but is it possible to have a system where one can enter 2 or 3 letters and the list directs you to words starting with these letters. This would be realy helpful since I always have long lists. Thank you for your kind attention Regards Albert |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Question
You could build a new list of them
=IF(ISERROR(SMALL(IF(LEFT($A$1:$A$20,3)="abc",ROW( $A$1:$A$20),""),ROW($A1))),"", INDEX($A$1:$A$20,SMALL(IF(LEFT($A$1:$A$20,3)="abc" ,ROW($A$1:$A$20),""),ROW($A1)))) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "albertmb" wrote in message ... Hi Everyone, Thanks for your continuos help and support. Wonder if anyone can help me: I am using the VLOOKUP formula. It works ok, but is it possible to have a system where one can enter 2 or 3 letters and the list directs you to words starting with these letters. This would be realy helpful since I always have long lists. Thank you for your kind attention Regards Albert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP() Question | Excel Worksheet Functions | |||
Vlookup Question | Excel Worksheet Functions | |||
VLOOKUP question...it probably can't... | Excel Discussion (Misc queries) | |||
Vlookup question | Excel Discussion (Misc queries) | |||
Vlookup question please | Excel Worksheet Functions |