ListboxSpinnerIndexLookup

ListboxSpinnerIndexLookup - So the table here won't work...

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

View Full Document Right Arrow Icon
This workbook is used to demonstrate Excel: "Forms" Toolbar Controls       * The Listbox       * The Spinner Indexing The lookup function       * VLOOKUP
Background image of page 1

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

View Full DocumentRight Arrow Icon
Forms Toolbar Controls The Listbox The List Apples Oranges Pears Grapes Kiwi Plums Bananas User's Choice: 1 The Spinner Spinner setting: 0
Background image of page 2
Syntax: =INDEX(table, row number, column number) A Fruit A Desert Select Your Favorite Fruit Apples Apple Pie Oranges Orange Souffle Pears Grapes Sugared Grapes Kiwi Just Plain Kiwi Plums Plum Pudding If you select Apples as the fruit, Bananas Bananas Flambe you'll get Apple Pie for desert. Nothing No desert! User's Choice: 1 Indexing  (plus a listbox control)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Lookup: VLOOKUP Syntax: =VLOOKUP(lookup-value, table, column number) Score Grade 0 F Mortimer's score is:  74 50 LP 75 HP Mortimer's grade is LP. 100 SP What happens if the table isn't configured properly? The first column should be sorted in ascending order.
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: So the table here won't work properly with VLOOKUP. Score Grade 100 SP Mortimer's score is: 50 75 HP Mortimer's grade is: #N/A 50 LP Mortimer's grade is: LP F Either sort the table, or use an additional parameter with the If you use this format of the command, VLOOKUP will return Alphabetic values can be used in the first column (not just numeric). Grade Score A 100 Mortimer's grade is: A B 75 C 50 The corresponding score is: 100 D 25 The HLOOKUP command works in the same way, but using the first row as the source of the lookup value. Score 50 75 100 Grade F LP HP SP Mortimer's score is: 85 Mortimer's grade is: HP VLOOKUP command: =VLOOKUP(H35, C35:D38, 2, FALSE ). an exact match, or if no exact match is available, #N/A. More Information...
View Full Document

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 4

ListboxSpinnerIndexLookup - So the table here won't work...

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