Find Jobs
Hire Freelancers

Excel Worksheet w/Multi sheet lookup

$30-250 USD

完了済み
投稿日: 4年以上前

$30-250 USD

完了時にお支払い
I'm trying to create a worksheet that will lookup & retrieve data from multiple sheets. This will require multi-sheet & multi-column lookup conditions with a return from a corresponding column. Example: The Summary page looks at Tab 1, Tab 2, Tab 3, & Tab 4 and looks for a condition on Tab 2 Column E on Tab 1 Column D and returns the value from Tab 1 Column E & F (added together) back to the Summary page. Similar formulas will be utilized multiple times.
プロジェクト ID: 20447083

プロジェクトについて

26個の提案
リモートプロジェクト
アクティブ 5年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hello, I can write a macro that will perform these lookups on a button click. Because regular formulas with multiple lookup criteria require helper columns and are highly inefficient with bigger data sets and multiple lookups, the macro will works great. I will make sure that it executes instantly, as I excel in macro speed optimization. If preferred I can also make the calculation not on a button click, but on activation of the worksheet where the output will be displayed. Best regards, Ryszard
$50 USD 2日以内
5.0 (64 レビュー)
5.2
5.2
この仕事に26人のフリーランサーが、平均$105 USDで入札しています
ユーザーアバター
Dear Employer, I understand your job. I am an expert with over 12 years of experience. Please check my reviews once!! Thanks and Regards, Ash
$250 USD 7日以内
5.0 (197 レビュー)
7.6
7.6
ユーザーアバター
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel workbook that will use advanced formulas like VLookup and HLookup in multiple sheets. I plan to use a combination of formulas as well as VBA code if needed, to accomplish this. The Excel file will run on PCs. I will charge you $200* and can deliver within five days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 300 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$200 USD 5日以内
4.9 (228 レビュー)
7.4
7.4
ユーザーアバター
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$120 USD 1日以内
4.9 (229 レビュー)
6.8
6.8
ユーザーアバター
Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many projects like this. Can you send me a message? Then we can discuss the details. Regards, Noor
$60 USD 1日以内
5.0 (249 レビュー)
6.9
6.9
ユーザーアバター
VERY EASY FOR ME Hi When it comes to Excel, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/Build-appraisal-record-card/?w=f https://www.freelancer.com/projects/excel/Need-HELP-this-excel-form/?w=f https://www.freelancer.com/projects/data-entry/add-excel-table-rows-outlook/?w=f https://www.freelancer.com/projects/php/create-outlook-add-rule-shortcut/?w=f https://www.freelancer.com/projects/data-entry/Macro-Copy-Paste-Excel/?w=f https://www.freelancer.com/projects/excel/Convert-Text-file-XML-file/?w=f https://www.freelancer.com/projects/data-entry/excel-expert-19406573/?w=f https://www.freelancer.com/projects/php/create-csv-file-using-parshub/?w=f https://www.freelancer.com/projects/excel/Excel-Spreadsheet-Formula-Add-Sum/?w=f https://www.freelancer.com/projects/excel/Compare-CSV/?w=f https://www.freelancer.com/projects/excel/ascii-excel-converter/?w=f https://www.freelancer.com/projects/software-architecture/Excel-xml-file-online-wizard/?w=f https://www.freelancer.com/projects/visual-basic/Repair-VBA-Problem-Types-don/?w=f https://www.freelancer.com/projects/software-architecture/Combination-creator/?w=f https://www.freelancer.com/projects/visual-basic/VBA-Access-Print-Word-PDF/?w=f https://www.freelancer.com/projects/excel/Need-split-csv-file-into/details I can show my product right now. I have a lots of experiences in Excel, Access and VBA programming Please contact me. Thanks
$50 USD 1日以内
4.9 (112 レビュー)
6.4
6.4
ユーザーアバター
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.
$80 USD 3日以内
4.6 (97 レビュー)
6.4
6.4
ユーザーアバター
I can definitely help you with that. I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro. I will be happy to discuss in detail.
$50 USD 1日以内
4.7 (51 レビュー)
5.4
5.4
ユーザーアバター
Hi There ! I'm interested in your project. I am detail oriented hard worker and honest. I assure that I will provide you Quality Work with 100% accuracy. My main goal is your satisfaction. If i get this chance to help you, I will do all of my best. Thanks !
$50 USD 2日以内
4.9 (37 レビュー)
4.6
4.6
ユーザーアバター
i can do this. i have good command over Ms excel especially pivot able, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks
$80 USD 1日以内
4.9 (21 レビュー)
3.9
3.9
ユーザーアバター
Hi, I have understand the project requirement & interested to make multi sheet lookup function for this project. I shall do it within very short time. Please send a message so we can discuss more & start the project. Thanks.
$30 USD 1日以内
5.0 (14 レビュー)
3.8
3.8
ユーザーアバター
Hi, I read all the necessities of your assignment and I must try to abide by all the requirements that you have mentioned in the project. If hired by you I will be responsible to complete the task within the stipulated time frame and with utmost confidence. I will give you high quality works in short time. I can provide faster service if needed. Outsource me for your project and I promise to bring in the best output. Please give me just one chance and see my hard work. Thank you.
$60 USD 1日以内
4.9 (16 レビュー)
3.4
3.4
ユーザーアバター
Hello Sir, Thanks for reading of my response. i understand your description, you need a Excel Expert who manage your project i.e. working with Excel and other administrative tasks. i have 12 years of experience as data entry, in Excel / spreadsheets, data collection, maintain eCommerce websites, web research, ms office and lead generation. I offer error free quality work, 100% data security and on time delivery, further modification is free of cost. Thanks and regards Hafiz Khalid Abdul Sattar
$140 USD 2日以内
5.0 (2 レビュー)
2.5
2.5
ユーザーアバター
i'm an Excel specialist. Making formulas working with different tabs is usual for me. Can do everything fast. Award me and you'll have the quick and good result.
$30 USD 2日以内
5.0 (1 レビュー)
1.3
1.3
ユーザーアバター
I'm interested in your project. Dear hiring manager I have gone through your project details and I am interested in it because I have been doing Bookkeeping, web research, skip tracing, lead generation and cold calling & appointment setting for Real Estate, Merchant Cash Advance and other Virtual Assistant jobs.i have 3 years experience for data entry. I have a large member of the team for done this project Please let's talk in details, thank you so much. Regards, Robiul Haque Melon Reply for more details ...
$30 USD 2日以内
4.9 (2 レビュー)
0.3
0.3
ユーザーアバター
Dear hiring manager I have gone through your project details and I am interested in it, because I have been doing Bookkeeping, web research, skip tracing, lead generation and cold calling & appointment setting for Real Estate, Merchant Cash Advance and other Virtual Assistant jobs. I have completed my MBA with Accounting and Business studies and having experience for real estate and merchant cash advance for USA since 2016. Please let's talk in details, thank you so much. Regards, Raju Biswas
$140 USD 7日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hello, I have read your project description and understood your requirement. I can complete the task within time with 100% accuracy. I am very responsible for our clients. I know my client needs and importance. I have previous working experience as well. Skills: Excel, Data entry, Copy typing, Web search, Transcription works, etc Thanks and Regards, Pooja
$140 USD 7日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hello. How are you? I have read the project description of 'DATA ENTRY SPECIALIST.' and I have confidence that I can carry the job to success. Cuz I am a professional full stack developer with over 4 years of experience and have been doing the kind of job for that period. Beside my skills in data base and data mining . my start was as cnc operator until I work in elmahd company as technical office engineer , I know the real meaning of work and time so I will not waste your time , Please initiate the private chat so that we can have full discussion on each other's offer and then we can start it immediately. Thanks and I am waiting for your contact.
$35 USD 1日以内
5.0 (1 レビュー)
0.0
0.0
ユーザーアバター
I done your work fast
$155 USD 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I have experience working with excel formulas, am a dedicated and fast worker. I garantee ontime delivery of the project.
$140 USD 7日以内
5.0 (1 レビュー)
0.0
0.0
ユーザーアバター
I will perform this task, data entry, and deliver it on time. I have worked with excel for a long time and thus I'll do it perfectly. Allow me to do this job for you and you'll never regret working with me. Thanks in advance
$30 USD 1日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
Birmingham, United States
5.0
4
お支払い方法確認済み
メンバー登録日:9月 4, 2018

クライアント確認

このクライアントからの他の仕事

Add field to Invoice in Crystal Reports
$15-25 USD / hour
ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。