womangerma.blogg.se

• #TUTORIAL ON PIVOT TABLES IN EXCEL 2013 CODE#

#TUTORIAL ON PIVOT TABLES IN EXCEL 2013 CODE#

In the VLOOKUP tab, place the cursor on the first activity code under Activity Number. The Activity Code in the Activity Codes file is numeric. The Activity Number in this query is text as indicated by the little diamond on the left top corner of the cell. The Activity Number in both files must have the same formatting. Vlookup_Hlookup file and the Activity Codes file. The Activity number is the link between this query in the General only shows in the panel because it is the first selection from the list.ī. Select “General” from the list of formats. On the Home tab, in the Number group, click on the down arrow in the field that shows “General”.ĭ. We will be doing the VLookup in the column titledĬ. Be sure you are on the VLOOKUP tab in the file. Because this worksheet contains query results extracted from the Data Warehouse, there are two formatting issues that must be resolved before doing a VLookup.Ī.

What we want to do is replace the generic names with the department assigned activity names.ġ0. If you look at the column titled “Activity Name” you see the generic Oracle names. This file contains the actual Department Names associated with the generic Activity Codes from Oracle.ĩ. Go to the desktop and locate the folder Data for Excel 2010 class.Ī. Select Computer, then under Network Location select Classroom Share or Hearthģ. Program C) with the department assigned names.įirst we will need to open our data files.Ģ. You prepare some data for the department head and you would like to replace the generic Oracle activity names (e.g. Zoology uses the generic activity codes in Oracle to analyze certain types of activities. Then show me specific information related to that value.” Go to another location and find the same value. When you use a lookup function in Excel, you are basically saying, “Here’s a value.