I am familiar with how vlookups work but I'm not sure I follow. The difficult
part of this is that one import may have more than one instance of the same
JobID (flattening of parent to child relationship) but the second import
will only be solely unique.
--
Greg



"CLR" wrote:

If you are not sure the rows will all line up appropriately, you should
import the two text files to two different XL sheets and then construct a
VLOOKUP formula to conjoin the data..........

hth
Vaya con Dios,
Chuck, CABGx3



"Greg" wrote:

I know there are a few similar posts out there but I want a little more
specific information.

I am going to be getting two text files from two different databases. All
information is coded to specific jobID numbers. I want to be able to import
one file and then the other. The part that may be tricky is I want to match
the second import information to the JobID from the first import.
I hope this makes sense.
--
Greg