VLOOKUP with the Smith and Jones of the world

  • Thread starter Thread starter RudeRam
  • Start date Start date
R

RudeRam

Is there a way that VLOOKUP will work when you have multiple last name
of say Jones and or, Smiths etc
 
Hi
lets assume you have in column A the last name and in column B the
first name (and that the combination of both is unique in your file).
Then use the following array formula (entered with CTRL+SHIFT+ENTER) to
get the associated value from column C:
=INDEX(C1:C100,MATCH(1,(A1:A100="lastname")*(B1:B100="firstname"),0))
 
Frank,

I am sorry I should have explained that I have last names in Col. A an
First in Col B. Can I still use the same formula as you have written?

Thanks
Ric
 
Frank,

Please disregard previous post, it's late and all my thoughts ar
blurring together, What I meant to say is I have the last names an
first initial in col A (I need them set that way for the form that the
are going into.) Can I use your same formula but omit the reference t
the first name in col B? Sorry for the confusion
 
Back
Top