Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

vlookup wildcard logic %

6 views
Skip to first unread message

eringreene <>

unread,
Apr 14, 2004, 12:07:11 PM4/14/04
to
can you use %wildcard logic in v-lookup?

so if i have a lookup formula with wildcard logic in one of the cells,
will v-lookup work?


---
Message posted from http://www.ExcelForum.com/

Ken Wright

unread,
Apr 14, 2004, 12:19:06 PM4/14/04
to
=VLOOKUP("*"&C1&"*",A1:B100,2,0)

=VLOOKUP("*def*",A1:B100,2,0)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"eringreene >" <<eringree...@excelforum-nospam.com> wrote in message
news:eringree...@excelforum-nospam.com...


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.656 / Virus Database: 421 - Release Date: 09/04/2004


Frank Kabel

unread,
Apr 14, 2004, 12:20:07 PM4/14/04
to
Hi
you may try the following array formula to search for *ad* in column A
and return the value from column B. Enter this formula with
CTRL+SHIFT+ENTER
=INDEX(B1:B100,MATCH(TRUE,ISNUMBER(FIND("ad",A1:A100)),0))

--
Regards
Frank Kabel
Frankfurt, Germany

0 new messages