The Vlookup function is a very useful function to know when you want Excel to lookup a value in one place and display/insert it in another. Initially the way Vlookup works in Excel; is it searches vertically for the value in the left most column of the table_array you specify, returning the value in the same row based on the index_number you selected.

Excel Formulas and Functions For Dummies From Excel Formulas and Functions For Dummies, 2nd Edition by Ken Bluttman, Peter G. Aitken Microsoft Office Excel is used to store data and crunch numbers in all types of businesses. The spreadhseet program's power lies in Excel functions and Excel formulas, which allow all sorts of data analysis,