Excel Table and Look up formulas needed

$10-30 USD

完了済み

投稿日:

6年近く前

$10-30 USD

完了時にお支払い

I have built multiple tables in an excel document. I need the formula that looks up data out of the table based on pull down ( Data Validation) =INDEX(INDIRECT("Table1["&C4&"]"),MATCH(B4,Table1[Labor],0)*MATCH(D4,Table1[Shift],0)*MATCH(E4,Table1[Zone],0)) I cant complete get this formula to work correctly. Also have the structure of a table in place and want to be able to pull data from the table based on multiple data validation list.

Excel

プロジェクト ID: 17133231

プロジェクトについて

11個の提案

リモートプロジェクト

アクティブ 6年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@NishchayTech

Hi I can do this now in 1 hour. I have 3 years experience working with Excel formulas and VBA. I'll complete it now.

$10 USD 0日以内

5.0

(16 レビュー)

4.2

この仕事に11人のフリーランサーが、平均$25 USDで入札しています

@datakillers

Hi I am ALISON certified for Microsoft Office specially Excel and Access Database. Data Entry and Processing is my passion with years of experiences. I am very hard working and know the value of time so, always deliver work on time. My motive is to make my employer happy with quality of service. If you are looking for data entry work I hope to deliver you the best of best services. Hire me to get the job Expertise

$29 USD 1日以内

4.9

(315 レビュー)

7.5

@afenache

Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. Also, you can find in my portfolio an excel file - automatic timekeeping sheet where I used a formula like yours. I will be pleased to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.

$30 USD 1日以内

5.0

(22 レビュー)

5.3

@jasalaz100

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.

$25 USD 1日以内

4.9

(30 レビュー)

4.9

@cyash61

Hello, I am an excel analyst with more than 6 years of experience working on excel. Please ping for details. Best, Yash

$50 USD 1日以内

5.0

(6 レビュー)

4.3

@Mfaisalshahzad00

Hi, I am expert in Excel Table and Look up formulas. I assure you, you will be another 100% satisfied client. Thanks.

$10 USD 1日以内

5.0

(17 レビュー)

3.9

@prasannjeetp

Hi, I have seen your proposal. I am an excel expert with very good knowledge of lookup formula and VBA. I can write formula to match index and pull right values in respective cells. Please come on chat for more details. Awaiting your response. Thank you.

$30 USD 1日以内