Is it possible to use a vlookup looking up peoples names

[Midd]

I would like to lookup a list of names but i have to have a set o
consecutive numbers before it. Is it possible to lookup names that ar
not consecutiv

 

[RagDyer]

If you set the last argument of the function to be an "exact" match, the
lookup column does *not* have to be in order.

=Vlookup(value to find,array or list of data,column to return,exact match or
not)
Exact Match = False OR Zero (0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I would like to lookup a list of names but i have to have a set of
consecutive numbers before it. Is it possible to lookup names that are
not consecutive

 

[Guest]

Midd
You lookup table does not have to be in consecutive order if you specify false (or zero) as the last component in your VLOOKUP function. A fourth term of false will return an exact match only

Regards
Mark Graesse
(e-mail address removed)

----- Midd > wrote: ----

I would like to lookup a list of names but i have to have a set o
consecutive numbers before it. Is it possible to lookup names that ar
not consecutiv