Prev: extract data from pivottable which meets certain conditions
Next: Import external data
From: John on 4 Jun 2010 17:40
Thanks, this answer also worked. I appreciate it.
--
John


"Roger Govier" wrote:

> Or avoiding the double lookup (hence marginally quicker)
> for XL2003 and earlier
> =IF(COUNTIF(A:A,G1),VLOOKUP(G1,A:B,2,0),"")
> for XL2007
> =IFERROR(VLOOKUP(G1,A:B,2,0),"")
>
> --
>
> Regards
> Roger Govier
>
> "Jacob Skaria" <JacobSkaria(a)discussions.microsoft.com> wrote in message
> news:09E6D7A2-0BCE-495A-BE6B-9B70A475F5BC(a)microsoft.com...
> > 1st post and well explained..
> >
> > Use VLOOKUP(). In H1 use the below formula and copy down as required
> >
> > =VLOOKUP(G1,A:B,2,0)
> >
> > If no match is found; it will return an NA# error which can be handled as
> > below
> >
> > =IF(ISNA(VLOOKUP(G1,A:B,2,0)),"",VLOOKUP(G1,A:B,2,0))
> >
> > --
> > Jacob (MVP - Excel)
> >
> >
> > "John" wrote:
> >
> >> This is my first question on this site, so I hope I hope this makes
> >> sense.
> >> I have vendor numbers in Col A-each vendor number would only be listed
> >> one
> >> time and not in numeric order. In Col B-- I assigned a number beside
> >> each
> >> vendor number in Col A. In column G, the same vendor numbers are listed
> >> but
> >> they may be listed more than one time and not in order. What I would
> >> like to
> >> do in Col H is if Col G has a match in Col A, I would like it to put the
> >> corresponding number from Col B in Col H.
> >>
> >> (Vendor#) (Vendor#)
> >> Col A Col B Col G Col H
> >> 123411 1 196879
> >> 102312 2 108810
> >> 108810 3 108810
> >> 196879 4 105554
> >> 105554 5 102311
> >>
> >> --
> >> John
> >
> > __________ Information from ESET Smart Security, version of virus
> > signature database 5170 (20100603) __________
> >
> > The message was checked by ESET Smart Security.
> >
> > http://www.eset.com
> >
> >
> >
>
> __________ Information from ESET Smart Security, version of virus signature database 5170 (20100603) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
From: John on 4 Jun 2010 17:43
Hi Steve, I do appreciate the help although I could not get this one to work
and maybe I was doing something wrong, however I do have my answer from the
post above
--
John


"Steve" wrote:

> Enter into H1
> =IF(A1=G1,B1,"")
> And copy this down as far as you need
>
> Regards
> Steve
>
> "John" wrote:
>
> > This is my first question on this site, so I hope I hope this makes sense.
> > I have vendor numbers in Col A-each vendor number would only be listed one
> > time and not in numeric order. In Col B-- I assigned a number beside each
> > vendor number in Col A. In column G, the same vendor numbers are listed but
> > they may be listed more than one time and not in order. What I would like to
> > do in Col H is if Col G has a match in Col A, I would like it to put the
> > corresponding number from Col B in Col H.
> >
> > (Vendor#) (Vendor#)
> > Col A Col B Col G Col H
> > 123411 1 196879
> > 102312 2 108810
> > 108810 3 108810
> > 196879 4 105554
> > 105554 5 102311
> >
> > --
> > John
First  |  Prev  | 
Pages: 1 2
Prev: extract data from pivottable which meets certain conditions
Next: Import external data