vlookup

Z

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)
 
J

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.
 
Top