Is it possible to use a vlookup looking up peoples names

  • Thread starter Thread starter Midd
  • Start date Start date
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
 
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
 
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
 
Back
Top