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
|