Re: Is there a way to do a vlookup to look up two columns versus one?

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 10:17:58 -0000

That's a good idea, and is very sound advice. But then we have come to
expect that :-)

Regards

Bob

"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:41F9ABA4.6094A45A@netscapeXSPAM.com...
> Just something to watch out for:
>
> It might be better to toss a character that won't appear in your data to
> separate those cells in the concatenation:
>
> =INDEX(Sheet2!$C$1:$C$100,
> MATCH(A1&CHAR(1)&B1,Sheet2!$A$1:$A$100&CHAR(1)&Sheet2!$B$1:$B$100,0))
>
> If you have:
>
> A B C
> RobVan Gelder 1
> Rob VanGelder 2
> RobVanGelder 3
> RobVanGelder 4
>
> You might not get the value you really want returned.
>
>
>
>
> Rob van Gelder wrote:
> >
> > Hey - I didn't know you could concatenate ranges for MATCH - very cool.
> > That's a very handy tip - thanks Bob.
> >
> > --
> > Rob van Gelder - http://www.vangelder.co.nz/excel
> >
> > "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> > news:uhjd6MMBFHA.2012@TK2MSFTNGP15.phx.gbl...
> > > Hi Joselle,
> > >
> > > Try this
> > >
> > > assuming the date is in A1, id in B1, and the other data is A, B and C
on
> > > *** 2,
> > >
> > >
=INDEX(Sheet2!$C$1:$C$100,MATCH(A1&B1,Sheet2!$A$1:$A$100&Sheet2!$B$1:$B$100,
> > > 0))
> > >
> > > this is an arrya form ula, so commit with Ctrl-Shift-Enter
> > >
> > > --
> > >
> > > HTH
> > >
> > > RP
> > > (remove nothere from the email address if mailing direct)
> > >
> > >
> > > "jpd" <jpd@discussions.microsoft.com> wrote in message
> > > news:47A267D1-46F4-429F-B0FC-C90F453481CF@microsoft.com...
> > >> I basically have Data set A with a date column and an id column and
other
> > >> data. I also have Data set B that contains the same date and id
column
> > > and a
> > >> third column. I want to be able to look at the data in Data set B
and if
> > > the
> > >> date and id match the date and id in Data set A, then put the
information
> > >> from that third column into Data set A. Can anyone help?
> > >> Thanks!
> > >> Joselle
> > >
> > >
>
> --
>
> Dave Peterson