excel computer course london - lookup

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer course london - Lookup

excel computer course london - Lookup

resolvedResolved · Low Priority · Version Standard

Michelle has attended:
Excel Advanced course
Excel Intermediate course
Excel Advanced course

Lookup

please explain more the benefits of Lookup

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.


 

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips


Server loaded in 0.09 secs.