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 www.bethanylb.edu/ 2 http://www.boisebible.edu/ 3 www.conservatory.edu/ 4 www.brynathyn.edu/ 5 www.butler.edu/ 6 http://www.canisius.edu/ 7 http://www.ccsj.edu/ COL C--------------------------------------- COL D 1 www.ab.edu/ 2 www.abc.edu/ 3 www.abconline.edu/ 4 www.ac.edu/ 5 www.aca.edu/ 6 www.academy.edu/ 7 http://www.boisebible.edu/-----------> 208-376-7743 8 www.boisestate.edu/ 9 www.brevard.edu/ 10 http://www.canisius.edu/-------------> 716-888-2525 11 www.carleton.edu/ 12 www.carroll.edu/ 13 http://www.ccsj.edu/------------------> (219) 473-4259 14 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 ? Thanks a lot !! Fabio
