Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
Microsoft Excel 6: Lookup and Logical Functions
Once a data table has been added to Excel, we regularly want to compare the data against existing data or categories, and find ways to combine the new information with existing concepts. Lookup functions like VLOOKUP allow us to combine tables or find a position within a range, and logical functions like IF allow us to build our own categories.
Topics include: