Excel PowerPivot DAX equivalent to INDEX MATCH


I have an existing Excel document that uses a lookup table to return specific values.

The working formula I use has this general structure =INDEX(MATCH([ ]&[ ],[ ]&[ ],0)).

This formula is quite long and Excel struggles to update values quickly.

To speed up my spreadsheet I have started to convert the Excel formula over to PowerPivot using DAX formula, which I can see will vastly improve overall speed and flexibility, but I need help on the journey!

The task at hand is quite small and defined. I would like the awarded person to use Excel 2013 or 2016 with the PowerPivot add-in, to present a table in the given format from the information provided in the given reference data. Please find attached an Excel file with the content in it.

There are 4 tabs to the Excel file.

Tab 1 - Contains Reference Data of the fixed value options for each field in Tab 2 and 3.

Tab 2 - Contains the lookup table that holds the values that need to be returned to Tab 4.

Tab 3 - Contains the working data file that staff will add rows to on a day-to-day basis.

Tab 4 - Shows an example of the PowerPivot Table I would like presented.

PowerPivot must return the correct 'Yield' and 'Grow Day' values, by cross referencing columns B, C, D and E of the 'Orders' Table against the look-up Table 'Yield and Grow Days'.



Fähigkeiten: Datenbankentwicklung, Datenbankprogrammierung, Excel

Mehr darüber Excel formula (Index Match) to be fixed, index-match, advance excel countif, if, sumif, v lookup, index,match, excel, index match, microsoft excel powerpivot, hi i am peter a freelancer based in england, hi i am looking for someone to craft our pdf documents in word we will send you 200 k version of documents hi i am looking for s, hi - i need someone to take a list of ~115 names and addresses that are currently in word and move them into, index match formula, vba excel powerpivot refresh, excel macro delete rows word match, excel powerpivot macro, excel powerpivot refresh tables macro, excel powerpivot macros, excel powerpivot refresh, excel powerpivot update vba, excel powerpivot, excel powerpivot vba

Über den Arbeitgeber:
( 1 Bewertung ) Geelong, Australia

Projekt-ID: #14990349

Vergeben an:


I have been developing software, reports and managing databases for clients on this website. I can develop your Excel PowerPivot excel application. I have 100% customer's satisfaction. Relevant Skills and Experien Mehr

$133 AUD in 3 Tagen
(21 Bewertungen)

12 Freelancer bieten im Durchschnitt $137 für diesen Job


I am highly qualified, experienced to work for you on this project. I am very fast and accurate. Relevant Skills and Experience I am a DataBase Developer/Programmer and an Excel expert. Proposed Milestones $177 AUD Mehr

$177 AUD in 1 Tag
(188 Bewertungen)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of ex Mehr

$160 AUD in 3 Tagen
(262 Bewertungen)

I have gone through the sample file. How many maximum rows are possible in tables? If there are less than 1,00,000 rows, Index/Match functions can work well, if it is slightly changed. Relevant Skills and Experience E Mehr

$35 AUD in 1 Tag
(128 Bewertungen)
$155 AUD in 3 Tagen
(52 Bewertungen)
$100 AUD in 1 Tag
(97 Bewertungen)

A proposal has not yet been provided

$137 AUD in 1 Tag
(38 Bewertungen)
$155 AUD in 3 Tagen
(3 Bewertungen)
$78 AUD in 2 Tagen
(18 Bewertungen)
$155 AUD in 3 Tagen
(0 Bewertungen)

We are a Team of Technical Consultants and Data Engineers having healthy experience into Big Data technologies,IOT/Cloud/AWS and Python/AI+Machine Learning. The Dynamic force has qualified engineers having expertise in Mehr

$154 AUD in 3 Tagen
(0 Bewertungen)

Tim, Hire me and I'll complete your project. See below a sample output with fields 'Yield' and 'Grow Day' calculated cross referencing columns B, C, D and E of the 'Orders' Table Let's talk. Relevant Skills and Ex Mehr

$200 AUD in 3 Tagen
(0 Bewertungen)