Hi, please help me out:

i have two excel files:

First File contains few numbers in A column:
eg:

5106134
5123866
773832

Now, i have another file which conatins some codes for these numbers,
but please note that the this file may conatain thie same number more
than 1 time as well, and all the times the code may be same or may not:
eg:

Second File:

5106134 SRST
5123866 ACSS
5106134 RPRG
773832 CHFO
5123866 SRST
5106134 CUED
5123866 ACSS
5123866 CUED

NOW, I AM APPLYING THE FORMULA IN FIRST FILe (VLOOKUP), AND I M GETTING
THE RESULT AS:

5106134 SRST
5123866 ACSS
773832 CHFO

WHEREAS I WASNTED TO CAPTURE ALL THE CODES FOR THE SAME NUMBER
HORIZONATLLY IN DIFFERENT CELLS:

I.E.

5106134 SRST RPRG CUED
5123866 ACSS SRST ACSS CUED
773832 CHFO


HOPE I M CLEAR IN MY SPECIFICATIONS, PLEASE HELP.

REGARDS,
VIJETA

PS: PLEASE DO NOT ADVICE ME FOR PASTE SPECIAL (TRANSPOSE), AS THAT IS
QUITE TEDIOUS, I HAVE THE SAME LIST IN THOUSANDS.


--
writetovijeta
------------------------------------------------------------------------
writetovijeta's Profile: http://www.officehelp.in/member.php?userid=68
View this thread: http://www.officehelp.in/showthread.php?t=649618
Visit - http://www.officehelp.in | http://www.officehelp.in/index/index.php/