{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ListboxSpinnerIndexLookup

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

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

This workbook is used to demonstrate Excel: "Forms" Toolbar Controls       * The Listbox       * The Spinner Indexing The lookup function       * VLOOKUP

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

View Full Document
Forms Toolbar Controls The Listbox The List Apples Oranges Pears Grapes Kiwi Plums Bananas User's Choice: 1 The Spinner Spinner setting: 0
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)

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

View Full Document
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.
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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online