Flashcards
Lookup Functions
Cards in this deck (4)
- 1VLOOKUPLook for values in a COLUMN.
- 2VLOOKUP EQUATION=VLOOKUP(search value, Lookup table, column,match)
*usually 2, FALSE
*If value is needed from another table ensure both tables are open. - 3HLOOKUPLooks for a value in a ROW
- 4HLOOKUP EQUATION=HLOOKUP(search value, lookup table, row, match)
Information
- Description
- Information Technology (Spreadsheets) Flashcards on Lookup Functions, created by Ciarra jeffries on 06/01/2017.
- Created by
- Ciarra jeffries · Jan 2017
- Updated
- Jan 11, 2017
- Views
- 1
- Rating