![lookup function in excel 2007 tutorial lookup function in excel 2007 tutorial](https://support.content.office.net/en-us/media/28e39ac1-7552-4258-90d5-b38b37deb2b1.png)
![lookup function in excel 2007 tutorial lookup function in excel 2007 tutorial](https://3.bp.blogspot.com/-xgbYSzcVcD4/VuzNL4ofWwI/AAAAAAAADUw/eq-A940v5Jw0jj4sXfqNhErHO-ODNXutQ/s1600/VLOOKUP%2BFORMULA.jpg)
TRUE (or 1) for yes, FALSE (or 0) for no. The Sorted/Unsorted is whether the column headings are sorted. The RangeToLookIn is the range of data with the column headings at the top.The RowToPickFrom is how far down the column the function should look to pick from. =HLOOKUP(ItemToFind,RangeToLookIn,RowToPickFrom,SortedOrUnsorted)The ItemToFind is a single item specified by the user. When the item is found, it then scans down the column to pick a cell entry.
![lookup function in excel 2007 tutorial lookup function in excel 2007 tutorial](http://cparesourcezone.com/excel_tutorials/assets/vlookup_function_syntax_example/vlookup3.jpg)
What is Hlookup?This function scans across the column headings at the top of a table to find a specified item. VLOOKUP - exampleSaturday, September 25, 2010An introduction to Microsoft ExcelDo you know? In a Excel 2007 Table, there are 16,000 Possible Columns and 1 Million possible Rows, that makes a total of 16,000,000,000 (16 Billion) Entries per table! TRUE for yes, FALSE for no.Saturday, September 25, 2010An introduction to Microsoft ExcelĬonsider the same exampleFind the value of Eric for Feb?=VLOOKUP(“Eric”,D3:G10,3,0) OR VLOOKUP(D8,D3:G10,3,0)We put “Zero” to inform computer that we require the exact valueWe put “one” to inform the computer that we require approximate value (nearest)Answer is 120Saturday, September 25, 2010An introduction to Microsoft Excel What is Vlookup?This function scans down the row headings at the side of a table to find a specified item.When the item is found, it then scans across to pick a cell entry.'=VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFrom,SortedOrUnsorted)The ItemToFind is a single item specified by the user.The RangeToLookIn is the range of data with the row headings at the left hand side.The ColumnToPickFrom is how far across the table the function should look to pick from.The Sorted/Unsorted is whether the column headings are sorted. What is lookup (Array)?This function looks for a piece of information in a list, and then picks an item from the last cell in the adjacent row or column.Formula: =LOOKUP(F12,D4:G10) OR LOOKUP(“Eric”,D4:G10) Saturday, September 25, 2010An introduction to Microsoft Excel
LOOKUP FUNCTION IN EXCEL 2007 TUTORIAL SOFTWARE
Until then, world used only one software – Lotus 123
LOOKUP FUNCTION IN EXCEL 2007 TUTORIAL FOR MAC
Lookup - ExampleSaturday, September 25, 2010An introduction to Microsoft ExcelDo you know? Microsoft originally marketed a spreadsheet program called Multiplan in 1982! Excel came out in 1985 – for MAC and in 1987 for Windows. This function looks for a piece of information in a list, and then picks an item from a second range of cells.=LOOKUP(WhatToLookFor,RangeToLookIn,RangeToPickFrom)The WhatToLookFor should be a single item.The RangeToLook in can be either horizontal or vertical.The RangeToPickFrom must have the same number of cells in it as the RangeToLookin.Be careful not to include unnecessary heading in the ranges as these will cause errors.Saturday, September 25, 2010An introduction to Microsoft ExcelĬonsider the table belowHow to find the value of Eric for Feb?Formula: =LOOKUP(“Eric”,D4:G10,F4:F10)OR =LOOKUP(D8,D4:G10,F4:F10)Answer: 120Saturday, September 25, 2010An introduction to Microsoft Excel Lookup is the simple function to return the value from a specific range. What is Lookup?In Excel, the Lookup function returns a value from a range (one row or one column) or from an array.
![lookup function in excel 2007 tutorial lookup function in excel 2007 tutorial](https://images.saymedia-content.com/.image/t_share/MTc1MDEzOTk0ODIwOTM3NTE1/guide-to-using-the-vlookup-formula-in-excel-2007.png)
Topics covered LOOKUP VLOOKUP HLOOKUPSaturday, September 25, 2010An introduction to Microsoft Excel Microsoft ExcelAn introduction to lookup functionPresentation by Vinod V Menon