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