Is column A sorted so that the entries are grouped or are the entries in
random order?

Is the value to be returned text or numeric or can it be either?

--
Biff
Microsoft Excel MVP


"Copying VLOOKUP formulas"
m wrote in message
...
i'm doing a vlookup in column A. let's say a value appears more than once
in
column A. the first vlookup result will be the first corresponding value
that appears, correct? how do I then alter the vlookup to find the 2nd
value? 3rd? 4th? 5th?

many thanks