Hello,
I have got three columns A, B, C.
In column A I have 7 fax numbers. In column B I have 7 URLs where faxes have been extracted from. In column C I have 14 URLs in which, among others, are included the exact URLs in column B.
I want associate faxes in column A with URLs (matched with those in column B) present in column C.
Ex.
COL A
1 1-785-227-2004
2 208-376-7743
3 (617) 912-9101
4 267-502-2658
5 (317) 940-9930
6 716-888-2525
7 (219) 473-4259
COL B
1 http://www.bethanylb.edu/
2 http://<woltlab-metacode-marker%20data-name=%22b%22%20data-uuid=%229636b74a-8397-4846-9a61-e934ac45721f%22%20data-source=%22w0jd%22%20/%3Ewww.boisebi…CXQ==%22%20/%3E
3 http://www.conservatory.edu/
4 http://www.brynathyn.edu/
5 http://www.butler.edu/
6 http://<woltlab-metacode-marker%20data-name=%22b%22%20data-uuid=%2283308ac2-b2f5-4947-8f9b-0a783c9281e5%22%20data-source=%22w0jd%22%20/%3Ewww.canisiu…CXQ==%22%20/%3E
7 http://<woltlab-metacode-marker%20data-name=%22b%22%20data-uuid=%22ad133d5b-c8a4-4554-9556-fe319cc2304f%22%20data-source=%22w0jd%22%20/%3Ewww.ccsj.ed…CXQ==%22%20/%3E
COL C--------------------------------------- COL D
1 http://www.ab.edu/
2 http://www.abc.edu/
3 http://www.abconline.edu/
4 http://www.ac.edu/
5 http://www.aca.edu/
6 http://www.academy.edu/
7 http://<woltlab-metacode-marker%20data-name=%22b%22%20data-uuid=%2258564a6d-ab86-46ae-8b08-4f5c4fccb864%22%20data-source=%22w0jd%22%20/%3Ewww.boisebi…CXQ==%22%20/%3E-----------> 208-376-7743
8 http://www.boisestate.edu/
9 http://www.brevard.edu/
10 http://<woltlab-metacode-marker%20data-name=%22b%22%20data-uuid=%2254205467-ca57-4f1e-82ae-85f742c7ace6%22%20data-source=%22w0jd%22%20/%3Ewww.canisiu…CXQ==%22%20/%3E-------------> 716-888-2525
11 http://www.carleton.edu/
12 http://www.carroll.edu/
13 http://<woltlab-metacode-marker%20data-name=%22b%22%20data-uuid=%2236843590-5241-40ca-b656-d668753064e8%22%20data-source=%22w0jd%22%20/%3Ewww.ccsj.ed…CXQ==%22%20/%3E------------------> (219) 473-4259
14 http://www.clemson.edu/
Which function should I use in order to get faxes in Col A and put them next to the appropriate URLs (matched with URLs in column B) in column C :confused: ?
Thanks a lot !!
Fabio