V-Lookups+in+Excel+2007

Often when processing a spread sheet, you will need to pull certain information from other tabs. This can be very time consuming as well create a greater risk of human error through redundancy. An easy solution for this is usuing the V-Look Up Function. The V look up function will insert the data from one sheet to another acording to the reference colum used. This is a very comon tool used in the business world today. The first step you will need to do is create a new column where you want the information to go: As you see in this simplified example, we need to find out what the branch name is, again this is a simplified example, for such a small amount of inputs you would just enter the information yourself, but if the list significantly larger, we would want to use out v-lookup function. The next step is to click into the first cell of our empty column, and then press the Fx (Function) button on the ribbon at the top. We will then select the funtion v-lookup The v-lookup criteria will pop up on the screen, and you will be prompted to enter the following information Since our reference in this case will be the Branch #, you will click into the first cell of data in that colum (B2) You will click into the appropriate sheet and left click the mouse on the heading of the reference column and drag to the cloumn that contains your information. once this is complete, you will hit F4, which in turn will enable you to use absolute references.
 * **Name** || **Branch #** || **Branch Name** ||
 * Jack || 83 || ||
 * Sally || 96 || ||
 * Jim || 49 || ||
 * Joe || 75 || ||
 * Lookup_Value** (This is going to be our reference column)
 * Table_Array** (This is the set of columns that exist in the second sheet where you are pull9ing your information out of. the set will be the range from your reference column all the way to the column that contains your needed data)
 * **Branch #** || **State** || **Town** || **# of Reps** || **Branch Name** ||
 * 49 || TX || Houstin || 5 || South Texas - East ||
 * 75 || TX || Austin || 8 || South Texas - West ||
 * 96 || TN || Franklyn || 6 || Tennessee ||
 * 83 || CO || Denver || 2 || Summit Surgical ||

**Column_Index_Value** (This is the count of columns that are chosen in the table aray above. If here are five columns from the reference column to the needed column, then your entry here will be 5 (See above chart For these basic purposes, you will likly always use false Now that the hard part is complete we see that the formula has been complied for the first cell in our column, whats left is to drag the formula down to the last entry of data. --> Bring down the formula <-- - Ilya Imyanitov (Section 11)
 * Range_Lookup** (Logical Statement - True / False)
 * ** Name ** || ** Branch # ** || ** Branch Name ** ||
 * Jack || 83 || Summit Surgical ||
 * Sally || 96 || ||
 * Jim || 49 || ||
 * Joe || 75 || ||
 * ** Name ** || ** Branch # ** || ** Branch Name ** ||
 * Jack || 83 || Summit Surgical ||
 * Sally || 96 || Tennessee ||
 * Jim || 49 || South Texas - East ||
 * Joe || 75 || South Texas - West ||