Class04 - GEEN 1300 Introduction to Engineering Computing...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1 1 GEEN 1300 Introduction to Engineering Computing Class meeting #4 Wednesday, Sept 1 st Spreadsheet Problem Solving Table-based operations Excel’s lookup functions Homework #2 is posted: due Wednesday, Sept 8 th 2 Table Look-up A great deal of information is organized in the form of tables and Excel provides a number of built-in functions that allow for the extraction of appropriate data from tables. Excel’s lookup functions are: LOOKUP VLOOKUP HLOOKUP MATCH INDEX OFFSET
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 3 LOOKUP(Lookup_value,Lookup_vector,Result_vector) search down the lookup vector find either a matching value, or a value greater than the lookup value, whichever occurs first go to the same position in the result vector, and extract the value there 4 Example of LOOKUP use text in alphabetical order create name “material” for this column this column will be the “lookup vector” numerical values of bulk density create name “density” for this column this column will be the “result vector”
Background image of page 2
3 5 Create LOOKUP function
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/07/2010 for the course CHEN 1300 at Colorado.

Page1 / 10

Class04 - GEEN 1300 Introduction to Engineering Computing...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online