Need excel Formula/Function to replace old File name with new File name.


I have an excel sheet with links, old and new file names, however I like to match the old file name to the downloaded file name by link.

So I need to match the new file name with the Old file name through the links, so I could rename the files. I can't organize/sort the files because they are missing some of the files.


Excel Old file sheet:

Old File Name Link

B120 [url removed, login to view]

B121 [url removed, login to view]

B123 [url removed, login to view]

New Downloaded file names sheet:

Link New file name

[url removed, login to view] Book230

[url removed, login to view] Book 2785

[url removed, login to view] Book75

New and old name match through Links - NEED Formula

Old File New File name (Formula)

B120 Book230

B121 Book75

B122 Book2785

See attached file please.

Thank you.

Beceriler: Veri İşleme, Excel

Daha fazlasını gör: sort function c, c sort function, excel sheet formula, excel formula, excel replace formula, need match files excel, excel match formula, need formula, formula sheet, file name excel, vb6 read excel file without excel, replace files, excel data match, replace file file, replace formula excel, need excel, need excel sheet, please attached file, need excel file chocolate, sheet names excel, processing sheet excel, excel formula function stock valuation, sort file excel, function data processing, can sheet names excel file

İşveren Hakkında:
( 24 değerlendirme ) Sacramento, United States

Proje NO: #6549727



Hello! I have the formula. Please send me chat to get that for $3 only. Regards Khurram .

$3 USD / saat
(24 Değerlendirme)

Bu iş için 8 freelancer ortalamada $5/saat teklif veriyor


Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan

$4 USD / saat
(21 Değerlendirme)

Hello, i am interested in this job can do it ether by macro or by a desktop application send me the full excel sheet to begin Regards

$4 USD / saat
(20 Değerlendirme)

A proposal has not yet been provided

$8 USD / saat
(4 Değerlendirme)

i have 2+ year experience in MS-Office 100% work satisfaction Guarantee ready to start working soon as assign

$4 USD / saat
(5 Değerlendirme)

100% job satisfaction. i am expert and professional in excel and doing excel modeling since 2011. i ll show you my previous work done. looking forward to work with you in the future.I know the time is so important. i w Daha Fazla

$2 USD / saat
(0 Değerlendirme)

A proposal has not yet been provided

$7 USD / saat
(0 Değerlendirme)

Hello :) need this job, please try me

$5 USD / saat
(0 Değerlendirme)