Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Office general help » Vlookup in Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Vlookup in Excel

Resolved · Low Priority · Version 2007

Reply Wed 28 Jul 2010, 11:09Delegate Ginger said...

Ginger has attended:
Upgrade to Office 2007 course

Vlookup in Excel

Is there a way to vlookup for phrases that contain the target word, rather than just the exact word match; the "true" option is too general for this; I run into this problem often for example with country or company lists that are written with slightly different names in the two sheets.

For upcoming training course dates see: Pricing & availability

Reply Thu 29 Jul 2010, 11:46Trainer Anthony said...

RE: vlookup in Excel

Hi Ginger, thanks for your query. Concatenate wildcards onto either side of the lookup value:

=VLOOKUP("*"&B19&"*", A1:C15, 3, FALSE)

That should find the lookup value even if it is in the middle of another string.

Hope this helps,

Anthony

Reply Thu 29 Jul 2010, 14:31Delegate Ginger said...

RE: vlookup in Excel

Thanks! Btw, is there a keyboard shortcut for these wildcards, as there is with the dollar signs?

Also, is there any way to pick up matches that are acronyms which don't actually contain the full word?

Reply Thu 29 Jul 2010, 15:14Trainer Anthony said...

RE: vlookup in Excel

Hi Ginger. The wildcards don't have an associated shortcut, unlike the dollar signs in formulas, you have to type the relevant wildcard into the formula as written. As for acronyms, you could potentially look for parts of the lookup value in the table array but that would involve an additional step to chop up the lookup value according to your specific criteria. Also, since it is an acronym, you would potentially be looking for just one letter which would be a minefield in a text field!

Hope this helps,

Anthony

Microsoft Office articles

· An Essential Guide To Customising The Navigation Ribbon In Office 2010
· How Office Can Transform Your Business Cheaply And Easily
· Reach For The Sky With Office 2010
· What To Look For In A Training Provider
· How To Paste Without Slicing Your Fingers

Please browse our web site to find out more about
sharepoint server courses and other Microsoft training courses.

Microsoft office tip:

Full Menu Display (Office 2003-2000)

One of the developments in Microsoft Office is that the Menu system has been optimized. This means that only recently used functions are displayed initially when you SINGLE CLICK on the menu.
There are many ways of getting around this:
1. DOUBLE CLICK on the menu bar, it will automatically expand
2. click on the DOUBLE ARROW you see on the bottom of the menu.
3. Wait for the menu to expand

If you always want to have the menus expanded:
4. On the menu bar, click TOOLS, then CUSTOMISE. Select OPTIONS, then uncheck the

View all Microsoft Office hints and tips