Chapter+5 - LOOKUP(value,lookup_vector,result_vector...

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

View Full Document Right Arrow Icon
    Excel #5 Retrieving Data for Computation,  Analysis, and Reference
Background image of page 1

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

View Full DocumentRight Arrow Icon
    Level I Reference and Lookup Functions VLOOKUP(value,array,column,[range]) Range match Exact match HLOOKUP(value,array,row,[range])
Background image of page 2
    Level II VLOOKUP and HLOOKUP from multiple  worksheets
Background image of page 3

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

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

Unformatted text preview: LOOKUP(value,lookup_vector,result_vector) INDEX(reference,row,column,area) Level III ISBLANK(value) CHOOSE(index_num,value1,value2…) OMIT: Very complicated example using all previous functions from this chapter....
View Full Document

This note was uploaded on 04/23/2008 for the course DISC 1300 taught by Professor Shemroske during the Spring '08 term at University of Houston.

Page1 / 4

Chapter+5 - LOOKUP(value,lookup_vector,result_vector...

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