Hi,

I have two worksheet, both worksheets have in common is the commune code. In
worksheet # 2 has the contact anme related to each commune code.
I want Excel to lookup for name from worksheet # 2 and put the lookup
information in worksheet 1 when the commune code is identical.

Could someone advice what formula I have to use in this case.

SF