Modify An Excel Formula

As you'll see in file attached, I have a formula to extract data from a crazy excel file - the purpose of which is to ultimately create a .csv file to load into a transportation dispatching app. The issue is with the columns E & H in the formula tab - extracting 'city'. It works if there are only two rows under the pickup address - it extracts "Portsmouth" under "615 Normandy St" - but returns a 0 under "106 Edison Ave." Now if I change the formula for "Edison" to: =IF(Data!A26="pickup",IF(Data!R28<>"",Data!D29,Data!D30)) - it works - but then I don't know how to nest this if it's indeed the right way to do it - with the existing formula: =IF(Data!A26="pickup",IF(Data!R28<>"",Data!D30,Data!D29)). Thanks!

Skills: Excel

See more: excel formula network address range, adjust an existing excel formula, i will provide names address phone email etc etc on a pdf file i need the information put in an excel spread sheet under company, edit formula in excel shortcut, what is the benefit of entering or editing a formula using the formula bar, excel formulas, relative reference excel, excel formula editor, how to change formula in excel for entire column, how to edit a formula in excel to relative reference, how to edit formula in excel for multiple cells, you are required to copy some data from a text file and move it into an excel file according to my instructions, there is a design that nomarlly appear in a flyer though i don t know what it is called but i really want to learn it, how much does it cost to hire an excel exper per hour, how to write it write an article for publication in your local newspaper on the need for ghana to have an indigenous language as, i have an event and want an artist but don t know how much they charge, Modify an Excel spread sheet and email it to customers using Mozilla Thunderbird, Reverse an Excel Formula, Attached is a scanned copy of a form that we need to be created as an Excel sheet, i have an idea for an app but don t know how to code

About the Employer:
( 2 reviews ) Chesapeake, United States

Project ID: #19018137

Awarded to:


Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$20 USD in 0 days
(298 Reviews)

3 freelancers are bidding on average $23 for this job


Hi Good Day! After reading your project details I believe I'm suitable for this project. As I'm an expert on it with more than 4 years of experience. WHY HIRE ME? *Professional service *Extra fast and timely More

$25 USD in 1 day
(2 Reviews)

Please give me oppurtinity to work

$25 USD in 2 days
(0 Reviews)