VLOOKUP Question

A

albertmb

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
 
B

Bob Phillips

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)
 
Top