vlookup and hlookup

• Please download This file
• Finding information in a table with a function.
• This is from page 373
• vlookup: vertical lookup
  • Data is in rows.
  • Gender table and class table.
• hlookup: horizontal lookup
  • Data is in columns.
• Exact match:
  • The data must be exactly the thing you are looking for.
    • No restrictions on the order of the table.
  • Approximate match: it is between two values
    • The table must be in increasing order.
• Three/four parameters
  • The thing you are looking for.
  • The table in which you are looking
  • The column/row you want back.
  • False-nothing for approximate match, true for exact match.
• The exercise
  • Look up gender
    • Switch the table order.
    • Fix the gender computation
  • Look up Class by code
  • Look up class code by hours
  • Look up up class by hours
  • Look up grade by percent
  • Look up comment by percent.
  • Look up comment by grade.
• There is a lookup command, but it is much more complex. You will not need it for my class.