Category Archives: Basic VLookup Information

Mike ‘ExcelisFun’ Girvin: “INDEX and MATCH How-To”

Mike ‘ExcelisFun’ Girivn checks in for day 3 of VLOOKUP WEEK 2012 with “INDEX and MATCH How To”. There are approximately 30 examples in this 1 hour ‘+’ video!

Example Files are available – Download files: https://people.highline.edu/mgirvin/ExcelIsFun.htm


Rahim Zulfiqar Ali: “Getting Started with New Ideas on LOOKUP”

From Rahim’s Post:
 
The Excel lookup function (LOOKUP, VLOOKUP and HLOOKUP) are not case sensitive. For example, if you write a lookup function to look up the text rahim, the function considers any of the following a match: RAHIM, Rahim or RaHiM
Example:
1. Create the sheet given below:
 
The figure below shows a simple example. Range D2:D7 is named Range1, and range E2:E7 is named Range2. The word to be looked up appears in cell B1 (named Value).  … To Read More Click Here to go to Rahim Zulfiqar Ali’s Lesson.

 

 

 

 

You may find Rahim Zulfiqar Ali Google Sites

Que Publishing: “Video Podcasts on VLOOKUP Formulas “

The QUE blog checks in for some mid-week Excel-lence:

“For day three of VLOOKUP Week, this two-part video podcast featuring Bill Jelen demonstrates the VLOOKUP Formulas in Excel. Bill Jelen, author of Excel 2010 In Depth offers a beginning and advanced look at VLOOKUP in these two videos. In video 1, matching data from two lists:! …Click here to continue on to the Videos presented at  Que Publishing Blog.

 


From The MS Office Blog: “VLOOKUP Tutorial: Updating prices in a master product list”

From Emily Warn at Microsoft Excel Blog:

“In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. You most likely know the core set of formulas that come with Excel and have heard that VLOOKUP is an easy way to look up a value in an Excel workbook, speeding up getting work done. But that’s about it.”… Click here to continue at Blogs.Office.Com

 


Neil Malek “Fun with VLOOKUP”

Neil has prepared a video for VLOOKUP WEEK 2012 entitled “Fun With VLOOKUP”!

“In this episode, Neil shows how the MATCH function and a little Data Validation can make the VLOOKUP function more user-friendly.”

 

You may find Neil Malek at TV.KnackTraining.Com


From Somkiat Foongkiat: “สูตร VLookup” [VLookup Formula]

VLookup in Plain Thai! Yes, Thai! MS Excel MVP Somkiat Foongkiat has sent in a contribution for our Thai Excel-lers!

“แม้การใช้คำสั่ง Data > Sort และ Data > Filter สามารถช่วยค้นหาข้อมูลที่ต้องการมาแสดงได้ง่าย ถ้าใช้คำสั่ง Sort ย่อมส่งผลทำให้ลำดับรายการของข้อมูลเดิมเปลี่ยนไป ต่างจากการสั่ง Filter ซึ่ง” คลิกที่นี่เพื่ออ่าน

Somkiat Foongkiat may be found at ExcelExpertTraining.com


From Oscar Evia: “Identificar los errores más simples de la funcion BUSCARV y como corregirlos”

Oscar Evia, of Universoexcel.com presents his first VLOOKUPWEEK [BUSCARV] Video entry this week. In Spanish, Oscar is Trouble-shooting VLOOKUP errors and offering solutions to correct them.

Episodio 127- BUSCARV (VLOOKUP Week)
“Hoy en el Video del Día y en honor de VLOOKUP week, usaremos su equivalente en español que es BUSCARV y veremos los pasos para usar esta función.”

For more on Oscar, you may follow him on Twitter @UniversoExcel or visit his website Universoexcel.com