ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Index Match Functions (https://www.excelbanter.com/excel-worksheet-functions/454267-index-match-functions.html)

Gene Haines April 12th 19 11:34 PM

Index Match Functions
 
I am trying to pull Labor dollars from sheet1 into sheet2 Total Dollars, however not having any luck

I need to actually have 3 match functions nested within the index function.
that match JO, TSTSD and KO.

Sheet1
JO TSTSD KO Labor Dollars
60770 JIJ7 010 $15,843

Sheet2
JO TSTSD KO Labor Hrs Total Dollars
60770 JIJ7 010 354 $15,843

This is the formula I want to put in column D Sheet2 TotalDollars
{=IFERROR(INDEX(Sheet1!$D$2:$D$64,MATCH(A2,Sheet1! $A$2:$A$64,0),MATCH(B2,Sheet1!$B$2:$B$64,0),Match) C2,Sheet1!$C$2:$C$64,))),0)}

Hope I am making sense. Any help is appreciated.

Regards

Gene

Claus Busch April 13th 19 08:30 AM

Index Match Functions
 
Hi Gene,

Am Fri, 12 Apr 2019 23:34:30 +0100 schrieb Gene Haines:

I that match JO, TSTSD and KO.

Sheet1
JO TSTSD KO Labor Dollars
60770 JIJ7 010 $15,843

Sheet2
JO TSTSD KO Labor Hrs Total
Dollars
60770 JIJ7 010 354
$15,843


try:
=SUMPRODUCT((Sheet1!A2:A64=A2)*(Sheet1!B2:B64=B2)* (Sheet1!C2:C64=C2)*Sheet1!D2:D64)


Regards
Claus B.
--
Windows10
Office 2016


All times are GMT +1. The time now is 07:35 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com