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