VLOOKUP+Formula

=Excel VLOOKUP Formula=

While working with several different worksheets, it can be difficult to find specific values or names, unless the VLOOKUP function is used. By using this function, we are able to find specific data stored anywhere in the spreadsheet table, by searching names or previously assigned codes. This relatively easy function can save a great amount of time and energy when working with broad data, therefore it is worth remembering.

In my simle example, I asked a few of my friends where we should spend our summer vacation. I will start off with making the name columns and a previously assign city code. On a seperate worksheet, I will place my "legend"- the code and its destination. Please notice that while I could assign the codes based on the first letter of the city, some of them start with the same letter (Las Vegas, Los Angeles). VLOOKUP allows me to assing any code I desire. Next, I will go back to my original workesheet and click at the cell where I wish to insert the code's look up. In order to do that, After filling out each of the formula's columns, (Lookup_value, Table_array, Col_index_num) I will be left with "VLOOKUP(C3,Sheet2!A2:B7,2,FALSE)" which I will insert under my Desired Destination. After I do that, "Las Vegas" automatically appears in cell D2.
 * 1. Go to the Formulas tab**
 * 2. Click on insert function**
 * 3. Type lookup; a pop out window comes out with four categories and their convinient, self explanatory description.**

The attached file shows exactly how the formula is being used.
The above example is short and simple, however imagine a situation with several different worksheets and a high number of product names on an inventory report. Previously assigned product codes could save hours of searching!

