Using vlookup function Please help

[CheckMeNot]

Hi,

I want to use this vlookup function but don't know what is the problem in my implementation.
I want to change the value of first worksheet column with the corresponding column of the second worksheet.
I know this can be done but I am missing something please help me with some example.

[Jaiwanti]

I am learning the macros in excel but I need to know this vlookup function for one of my assignment. If you guys can please let me know how can I implement this function in my workbook step by step with an example it will be a great help.
Please guide me to some tutorial or guide.

[Jhonwho]

Using the VLOOKUP Function
Excel’s VLOOKUP function uses 4 pieces of information.
To lookup a value using VLOOKUP
1. Add your new column on your original worksheet that will display the info pulled from the Lookup table.
2. Place your cursor in the first blank cell in that column.
3. From the Insert menu, select Function…. The Insert Function dialog will appear.
4. In the Search for a function: text box, type “vlookup” and click Go.
5. Highlight VLOOKUP and click OK.
Defining the VLOOKUP Values
After you click OK, Excel’s Function Arguments dialog appears and allows you to define the four values. You’ll see that your starting cell and the formula bar show the beginning part of the function =VLOOKUP(). The Function Arguments dialog adds the needed data elements that will display between ().
1. Lookup_value – Think of this field as your starting point.
2. Table_array – This is the range for your lookup table. The range can be on your existing worksheet or another worksheet.
Col_index_num – This is the number of the column on your lookup table that has the information you need.
Range-lookup – this field defines how close a match should exist between your Lookup_value (C2) and the value in the leftmost column on our lookup table.
For detail example.

[Amaresh]

I have a problem in my excel vlookup function is that I require the leftmost column to be presorted in ascending order.
The problem is that the column 1 gets changed constantly. But the sorting changes the order of column 2. How to tack care of this problem? Please help me.