Is it possible to use a vlookup looking up peoples names

M

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
 
R

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
 
M

Mark Graesser

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
[email protected]

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