Excel Table and Look up formulas needed

$10-30 USD

Completed

Posted

almost 6 years ago

$10-30 USD

Paid on delivery

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

Project ID: 17133231

About the project

11 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 0 day

5.0

(16 reviews)

4.2

11 freelancers are bidding on average $25 USD for this job

@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 in 1 day

4.9

(315 reviews)

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 in 1 day

5.0

(22 reviews)

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 in 1 day

4.9

(30 reviews)

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 in 1 day

5.0

(6 reviews)

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 in 1 day

5.0

(17 reviews)

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 in 1 day