J
John
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
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