Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLOOKUP and "contains"

	98.1 % recommend us
	More live stats...

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

Training information:

VLOOKUP and "contains"

Resolved · Urgent Priority · Version 2003

Reply Tue 5 May 2009, 12:32Delegate Adam said...

Adam has attended:
Excel Intermediate course

VLOOKUP and "contains"

Hi all,

I have a list of random addresses that may or may not be the full correct address according to a GVT database.

I have over 15000 lines of them and the GVT Database has over 120 000 lines.

I need a vlookup that can contain 'variables' to search the list of my addresses and lookup in the GVT database.

eg: MY ADDRESS

1. 19C St Georges

GVT DB:

1. Flat C 19 St George's Avenue London

Is there any way to do this.

Thanks for all and any help.

For upcoming training course dates see: Pricing & availability

Reply Wed 6 May 2009, 13:46Trainer Jacob said...

RE: VLOOKUP and "contains"

Hi Adam

Okay I will need to consult one of my colleagues on this and let you know what we can do.

Regards

Jacob

Excel articles

· Create Date Sensitive Colour Changing Cells In Excel
· The Best Way To Use Clip Art Images In Excel
· How to Create Better Excel Spreadsheets: Part Three
· Sorting Out Your Data In Excel
· What's In A Number? Make Figures Mean More Via Excel

Please browse our web site to find out more about
vba for excel training and other Microsoft training courses.

Excel tip:

Excel 2010 Shortcuts - Start and End of the Worksheet

Did you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard?

Press Ctrl + Home key to move the cursor to cell A1

Press Ctrl + End key to move the cursor to the end of the current worksheet.

View all Excel hints and tips