Excel Lookup/Search Tip 2 - Vlookup Explanation 1 - Display Product Suppliers from a List/Database

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to use the VLOOKUP() function in Microsoft Excel. This tutorial will give you a walkthrough to using the Vlookup function. You will learn the arguments for the vlookup function and how to use them to search a database of parts in order to return the desired value. This is a great tutorial for people who need to learn the vlookup function for Excel.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• vlookup
• functions
• formulas
• excel
• vlookup in excel
• walkthrough
• examples
• search database

[elljaysa]

What if you are looking for a "begins with"? I.e. the data you are searching for in the leftmost column is ASD1457376, but you only want to look for "ASD"s rather than having to specify all possibilities...

Any ideas?

[ExcelisHell]

You would use some text manipulation functions to pull three characters from the left of the cell into perhaps a variable and then check that variable. That should do the trick. I don't have sample code off the top of my head but just search for vba text manipulation like the left() function and integrate that into your code.

[elljaysa]

@ExcelisHell

Yep, that helped:

=Vlookup(LEFT(A1,3)etc,etc,2,F­alse)

Cheers!

[ExcelisHell]

Glad it helped. For some reason I thought this was a vba tutorial but luckily the functions are similar enough to have helped.

[arespinoza85]

Perfect, Thanxs a million this video really helped me :-)