vlookup-all the data to the right of it whats the fromula ?

[Zygan]

if i have a list


1
2
3
4
5
6
1

and i want to use the vlookup function to return the second 1 value and all the data to the right of it whats the fromula ? (assuming i have data to the right)

[JLatham]

From Excel Help on VLOOKUP():
"If there are two or more values in the first column of table_array that
match the lookup_value, the first value found is used. If an exact match is
not found, the error value #N/A is returned."

Basically that says it's always going to pick up the values from the 1st
matched value and never see the second duplicate value. Sorry.

"Zygan" wrote:

>
> if i have a list
>
>
> 1
> 2
> 3
> 4
> 5
> 6
> 1
>
> and i want to use the vlookup function to return the second 1 value and
> all the data to the right of it whats the fromula ? (assuming i have
> data to the right)
>
>
> --
> Zygan
> ------------------------------------------------------------------------
> Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
> View this thread: http://www.excelforum.com/showthread...hreadid=550179
>
>