How do I lookup and return different values when the lookup value.
 

I am trying to do a vlookup for data where the same array is used more than
once so it always returns the first value. How do I have it return the other
corresponding data.

Try looking at Data Filter AutoFilter............it will return all the
rows that has the criteria condition........

Vaya con Dios,
Chuck, CABGx3


"kg" wrote in message
...
I am trying to do a vlookup for data where the same array is used more
than
once so it always returns the first value. How do I have it return the
other
corresponding data.