Look up columns problem with List Templates.

When we try to recreate the lists with look up columns from one site to another site, we lose the look up connection.

For example if have two sites 

A and B

A has list called A1 which has a look up column referring List AL1

If you want to take a copy of list A1 and recreate it in site B as B1 with look up referring to BL1.

Follow these steps

1. Save List A1 as template (.stp).
2.  Go to site collection settings.
3. open the list template gallery.
4. Save the A1's template in your computer.
5. Go to the .stp file saved in you computer.
6. change its extension to .cab 
7. open the ziped file and extract the files in it to a folder.
8. Open the manifest.xml file in notepad (or any other text editor).
9. search for the GUID of list AL1 and replace it with GUID or BL1.
10. save the manifest.xml file
11. open command prompt and type the command "makecab manifest.xml template1.stp".
12. It creates the template1.stp file.
13. Upload template1.stp to the site collection of B site.
14. create the list B1 using template1.stp.
15. If you have multiple look up fields repeat the step 1 to 14 for all those fields.

If this is post is helpful, please leave a comment. Thanks.