Data Sets

False forces an exact match to be found vlookup table

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: UC) and reports the value in the second column, Some Coll. FALSE forces an exact match to be found. VLOOKUP Table HGA Educ 31 8 32 8 33 8 34 8 35 9 36 10 37 11 To change the Education variable mapping, simply change the values of the cells in J6:J20. 38 11.5 The two buttons are just a short-cut for doing two possible mappings. 39 12 40 13 Remember to refresh the Pivot Table after you change the mapping. 41 13 42 14 43 16 44 18 45 18 46 18 Use Excel's Help on VLOOKUP to get more information. GMSTCEN State 31 Ohio 32 Indiana 33 Illinois 34 Michigan 35 Wisconsin SALES DATA BY DATE AND SALES REP 1/6/2012 East Parent Binder DRing 74 1/6/2012 East Jones Pencil 95 1.49 141.55 1/6/2012 East Jones Pencil 80 15.99 1,183.26 1.49 119.20 1/23/2012 Central Kivell Binder DRing 50 15.99 799.50 1/23/2012 Central Kivell Binder DRing 95 15.99 1,519.05 1/23/2012 Central Gill Binder DRing 5 15.99 79.95 2/9/2012 Central Parent Pen 75 1.99 149.25 2/9/2012 Central Jardine Pencil 36 1.49 53.64 2/9/2012 Central Ja...
View Full Document

Ask a homework question - tutors are online