help getting data

[Aceavl]

Hi, i'm new using excel and i came across a problem.

i have to pages, in page 1 i have a list of names in page 2 i have a list of names and a currency column.

what i want to do is select a name from page 1 and have excel look for it in page 2 and get the currency value.

how can i modify the vlookup function so it returns not the "match" but the next column?

thanks

[Ikaabod]

Example:

=VLOOKUP(E1,A1:D16,4,FALSE)

The "4" tells excel to display column D of the range A1:D16.
The search will only take place in the left most column (column A in this example) and will display column D (4th column of the range) of the row in which the value was found in column A.

The range and the column number can change as you see fit.

Note: If your range is only 3 columns wide and you set the formula to display the 4th column this will cause an error.

Hope that helps you.

[Aceavl]

thank you for explaining how vlookup works, that was exactlly what i was looking for!