vlookup
 

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

vlookup
 

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

vlookup
 

entries are in random order.

desired returned values are text and numeric.



"T. Valko" wrote:

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