Terminé

Simple formula for Excel Experts

The purpose of this project is to be able to work out the days in between the date in which we received the order to the date we placed it on the freight truck.

In the attached file are three sheets. One has the invoice number (Sale), the other two (EFM & TOLL) are the data of the freight trucks. The sheet with “EFM” has a few different freight companies, the sheet with “TOLL” has the one company.

To give you an idea with what I’ve done so far, F23 is picking up from the Toll sheet, the date that matches the invoice number. G23 then calculates that it was 6 days.

I need columns C & E to pick up columns B from both sheets if there is a corresponding invoice number. I’m not sure how to do a Vlookup formula that allows you to pick up the invoice number in column A where there are more than one value, such as Cell A8 in Sheet ‘Toll’ where there are two invoice numbers.

In the ‘EFM’ sheet, the invoice numbers also include another set of numbers that are irrelevant to the workbook. For example, Cell A2, only relevant data is 27264, therefore V49779732 needs to be discarded.

Also, A32 has this data “V50088895,27633, 27646, 27646,27633, S50075896”, therefore only 27633, 27646, 27646,27633 are relevant. Does this make sense?

I have put in some Vlookups in row 2 on the Sales sheet so that you can see what data I need if there were no issues with the formula.

Hope this makes sense.

My Budget is 20 SGD

Thank you.

Compétences : Saisie de Données, Traitement de Données, Excel, Visual Basic

en voir plus : interest payment formula excel, simple gui excel, need excel experts, microsoft excel formulas list with examples, excel examples, advanced excel formulas, excel formulas pdf, excel formulas cheat sheet, excel formulas, ms excel formulas list, excel formula list download, advertising formula excel, formula excel, simple database excel, convert excel formula simple formula, make simple formula excel, simple formula excel, excel simple formula, simple macro formula excel, simple dietz excel formula

Concernant l'employeur :
( 2 commentaires ) Singapore, Singapore

Nº du projet : #17551007

Décerné à:

mail2vimalarora

Hi, I have gone through your project details and has corrected changes needed in VLOOKUP function as you needed per your requirement. You can checkout output coming in excel at url : [login to view URL] Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% SGD en 0 jours
(78 Commentaires)
5.7

12 freelance font une offre moyenne de $22 pour ce travail

royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(71 Commentaires)
5.3
TechnoGuruu

Hi, I have checked your requirements and the attached sheet with all the data. Actually in this case vlookup will not work and I think none of Excel formula will work in this case because data is very random. Some c Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 3 jours
(35 Commentaires)
5.0
NeetuSinghal

Hi, I have 9 yrs of experience in data analytics with [login to view URL] in Operational Research. Data Analytics - I have done data modeling since last 9 years a and created more than 200 models. Experience in analytical Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(11 Commentaires)
3.6
kankshi619

Hi I have been regularly working on excel formulas and can handle this as desired by you. The work will be done well within the timeline.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 2 jours
(10 Commentaires)
3.2
paulodayto08

Hi I am a PMO analyst and my primary task is doing Financial reports and analysis. I am exposed in different formulas and function of Ms Excel. I am also a VBA Macro developer which may help me to complete this projec Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(4 Commentaires)
2.5
sevillajk01

hi! let me help you with your project. Just award the project to me and I will do as you requested. thanks I have seen your excel file and I can deliver it to you in less than a day.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(7 Commentaires)
2.4
ananthgadag

Hi, I have 8 years of experience working on excel files and formulas. I would be happy to help you get the formulas worked out as per your requirement. Thank you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(7 Commentaires)
2.2
sherryanneaquino

Hi My name is Sherry Anne Aquino, coming with me is my 10 years of experience as a Virtual Professional. I have enough experience in different areas of online jobs. I have tried and completed several projects lik Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(5 Commentaires)
1.8
Baderah

Being a n investment banker, making presentation and financial models are central to our professional life. Therefore, I am advance user of MS Excel and Ms Power point. For more details kindly contact me

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(4 Commentaires)
1.7
AkidAizat

I have an adequate knowledge in Microsoft and Computer skills. I strive to deliver Quality work in a short amount of time

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% SGD en 2 jours
(0 Commentaires)
0.0
anisarkar985

Dear Hiring Manager, Thanks, you for posting your jobs opening. I am expert in Excel project and I have performed all of the duties listed in your job description that I assured. My excel skill and typing speed makes Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% SGD en 1 jour
(1 Évaluation)
0.0