What function should I use?

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 data-name="b" data-uuid="9636b74a-8397-4846-9a61-e934ac45721f" data-source="W0Jd" />www.boisebible.edu/<woltlab-metacode-marker data-uuid="9636b74a-8397-4846-9a61-e934ac45721f" data-source="Wy9CXQ==" />
3 http://www.conservatory.edu/
4 http://www.brynathyn.edu/
5 http://www.butler.edu/
6 http://<woltlab-metacode-marker data-name="b" data-uuid="83308ac2-b2f5-4947-8f9b-0a783c9281e5" data-source="W0Jd" />www.canisius.edu/<woltlab-metacode-marker data-uuid="83308ac2-b2f5-4947-8f9b-0a783c9281e5" data-source="Wy9CXQ==" />
7 http://<woltlab-metacode-marker data-name="b" data-uuid="ad133d5b-c8a4-4554-9556-fe319cc2304f" data-source="W0Jd" />www.ccsj.edu/<woltlab-metacode-marker data-uuid="ad133d5b-c8a4-4554-9556-fe319cc2304f" data-source="Wy9CXQ==" />


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 data-name="b" data-uuid="58564a6d-ab86-46ae-8b08-4f5c4fccb864" data-source="W0Jd" />www.boisebible.edu/<woltlab-metacode-marker data-uuid="58564a6d-ab86-46ae-8b08-4f5c4fccb864" data-source="Wy9CXQ==" />-----------> 208-376-7743
8 http://www.boisestate.edu/
9 http://www.brevard.edu/
10 http://<woltlab-metacode-marker data-name="b" data-uuid="54205467-ca57-4f1e-82ae-85f742c7ace6" data-source="W0Jd" />www.canisius.edu/<woltlab-metacode-marker data-uuid="54205467-ca57-4f1e-82ae-85f742c7ace6" data-source="Wy9CXQ==" />-------------> 716-888-2525
11 http://www.carleton.edu/
12 http://www.carroll.edu/
13 http://<woltlab-metacode-marker data-name="b" data-uuid="36843590-5241-40ca-b656-d668753064e8" data-source="W0Jd" />www.ccsj.edu/<woltlab-metacode-marker data-uuid="36843590-5241-40ca-b656-d668753064e8" data-source="Wy9CXQ==" />------------------> (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

Re: What function should I use?

Hi Maqbool,

Thank you for your reply.
Unfortunately this is not what I am looking for. The URLs in the Col C must be copied and pasted in an existing database togheter with the associated fax. If I just get the URLs with the fax combined and exclude all other URLs in the Col C I cannot copy and paste into the existing databse. In your excel sheet there is no function in the Column D where the faxes sould be associated. Faxes are just manually copied and pasted.

Thanks anyway for your time . I appreciate it.

Fabio

Re: What function should I use?

Hello Maqbool

I received another formula

=IF(ISNUMBER(MATCH(C1,$B$1:$B$7,0)),INDEX($A$1:$A$7,MATCH(C1,$B$1:$B$7,0)),"")

It is working properly.

Thanks anyway for your time.

Cheers,

F