need some help on formula

[excelnoob11]

Hi All

I need some help

I got 2 excel work books.

File1.xls is populated like this

A1
C:\map1\map2
A2
C:\map1\map3
A3
C:\map1\map3
A4
C:\map1\map4

B1
blank
B2
blank
B3
blank
B4
blank




File2.xls is poplulated like this

A1
C:\map1\map2
A2
C:\map1\map3
A3
C:\map1\map3
A4
C:\map1\map4

But the
B1,b2,b3,b4 are populated with emaladdresses matching the path


I want if A1 from File1 matches with A1 from File2 it adds the mail address from File 2 to File 1


The reason for that is that File 2 is file fully populated with email address some of the match with the path C:\map1\map2 etc some not.

[arlu1201]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[excelnoob11]

You can close it

I find the solution using VLOOKUP

[arlu1201]

Its great that you managed to solve your question through vlookup. In future, please ensure that your thread title conforms with the forum rules.