View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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