Which function should I use to ....

[world33]

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 www.boisebible.edu/
3 www.conservatory.edu/
4 www.brynathyn.edu/
5 www.butler.edu/
6 www.canisius.edu/
7 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 www.boisebible.edu/-----------> 208-376-7743
8 www.boisestate.edu/
9 www.brevard.edu/
10 www.canisius.edu/-------------> 716-888-2525
11 www.carleton.edu/
12 www.carroll.edu/
13 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

[Bryan Hessey]

Hi,

If your data in columns A and B were reversed, then you could use vlookup.

Insert a new Column C and copy Column A to the blank Column C, then delete Column A.

In cell D1 put

=IF(ISERROR(VLOOKUP(C1,A$1:B$999,2,FALSE)),"",VLOOKUP(C1,A$1:B$999,2,FALSE))

where the range A$1:B$999 needs to specify the range of your data.

Hope this helps

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 www.boisebible.edu/
3 www.conservatory.edu/
4 www.brynathyn.edu/
5 www.butler.edu/
6 www.canisius.edu/
7 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 www.boisebible.edu/-----------> 208-376-7743
8 www.boisestate.edu/
9 www.brevard.edu/
10 www.canisius.edu/-------------> 716-888-2525
11 www.carleton.edu/
12 www.carroll.edu/
13 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