VLookup - Retrieve more than one field

[msantoso]

hello everyone, 

I've searched for an example before posting a new request, but could not find any. 

Sorry if in case, my question has already been answered :)

I have a file containing company numbers and a grouping code.

My second file contains this grouping code and many other fields. 

I'd like to join the two files and copy into the first file two specific fields.

Could anyone explain how to do that ?

many thanks

 ms

[agentzerow · Accepted solution]

i pulled together a few ways of achieving your output with the join tool.

[msantoso]

THANK YOU !! 

hi AgentZerow, you made my day!!

Have a nice day

myriam