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

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