Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer course london - Lookup
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel computer course london - Lookup
Resolved · Low Priority · Version Standard
Reply Fri 9 Nov 2007, 15:56Delegate Michelle said...
Michelle has attended:
Excel Advanced course
Excel Intermediate course
Excel Advanced course
Lookup
please explain more the benefits of Lookup
For upcoming training course dates see: Pricing & availability
RE: Lookup
Hi Michelle, Thank you for the post, in answer to your question, Lookup functions are used to extract a result from a table of data, to extract the information you will need to provide a lookup value (search criteria), this should be in a separate cell and should refer to a value or label from column/row 1 in the table, the Lookup function will then look for the intersection of this row or column with an indicated row or column, and will return the value or label. Lookups are either Vlookup or Hlookup, (Vertical or Horizontal). The syntax for a Vlookup table would then be; =VLOOKUP(Lookup_value,Database_cell_range,Column_to_search,Type_of_Lookup Type of lookup can be either TRUE or FALSE. If TRUE is indicated, the values must be sorted in ascending order, Lookup will then return the value equal to or less than the search criteria from the intersecting cell. I hope that helps, regards Pete.
|