Excel Table and Look up formulas needed

$10-30 USD

Teljesítve

Kiadva ekkor:

majdnem 6 évvel ezelőtt

$10-30 USD

Teljesítéskor fizetve

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

Projektazonosító: 17133231

A projektről

11 ajánlat

Távolról teljesíthető projekt

Aktiválva: 6 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@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 napon belül

5,0

(16 értékelés)

4,2

11 szabadúszó adott átlagosan $25 USD összegű árajánlatot erre a munkára

@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 napon belül

4,9

(315 értékelés)

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 napon belül

5,0

(22 értékelés)

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 napon belül

4,9

(30 értékelés)

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 napon belül

5,0

(6 értékelés)

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 napon belül

5,0

(17 értékelés)

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 napon belül