**What Does It Do?**These functions are used to search down the row headings at the side of a data to find a particular item. When it is found the item, it then search across to pick a cell entry.

**Syntax**=VLOOKUP(Lookup_Value,Table_array,Column_Index_Num,Range_Lookup)

The Lookup_Value is use a single item individual by user. The Table_array is the row headings with the range of data in the left hand side. The Column_index_num is use to how far across the table the function should show to pick from. The Range_Lookup is used to the column headings are sorted. TRUE for yes, FALSE for no.

**Formatting **These functions have no any special formatting needed.

**Example 1**These tables were used to find a value based on a specified name and month. These =VLOOKUP() functions are used to look into behind to find the name in the data. These problem are arises when we need to look across to find the month column. We are used this =MATCH() function for to solve the problem.

This =MATCH() function is use to show through the list of names to find the month we require. It then calculates the position of the month in the list. Because these list of months are not as wide as the lookup range find, then the =MATCH() number is 1 less than our require, so and extra number 1 is added to give back. These =VLOOKUP() functions with used this =MATCH() function to show the number across the columns and picks out the Wright cell entry. These =VLOOKUP() functions are used to FALSE for indicate to Excel in the end of the function that the row headings are not sorted.

**Example 2**These example look to how the =VLOOKUP() are used by a spare part shop for pick the cost of different makes of cars. These =VLOOKUP() functions are scans down the row headings in the column F for the spare part entered in the column C. When we are want to found make part, the =VLOOKUP() then scans across to find the price, and we are using the =MATCH() function to find the position of the maker of cars parts.

These functions are used the absolute ranges indicated by the dollar symbol. When we are copied this formula to more cells, then the ranges for =VLOOKUP() and =MATCH() do not change.

**Example 3**These examples are used by a builders merchants offering discount in the large order. Unit cost table holds of cost 1 units of Brick, Wood and Glass. This discount table holds the various discounts of different quantity of each product. These order tables are used to entered the orders and calculates the total. In the orders table all the calculations take place. We are typed the item name in the column C of the order table. These unit costs of the item are show in the units cost table. The FALSE options have been used to end of functions to indicate that the product names down the unit cost table are not sorted. We are using the FALSE option forces the function to search for an extract match. Whenever the match is not fount, then the functions is show the error. These discounts are then showed in the Discount Table. If the ordered quantity matches a values at the side of the discount the =VLOOKUP() will show across to find the correct discount. These TRUE options have been used to indicate at the end that the values shows down the side of the Discount Table are sorted. We are use the TRUE for allow the function to make an approximate match. If the Ordered quantity does not match a value at the side of the Discount Table, then the next lowest value is used. When we are try to match an order of 125 will be drop down to 100, and the discount from the 100 row is used.