Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 Last edited by Gene Haines : April 12th 19 at 11:37 PM |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX MATCH Functions in LibreCalc (Excel) - Non unique valuesreturn wrong index result | Excel Worksheet Functions | |||
Index and Match functions I think | New Users to Excel | |||
Row, Index, Match functions | Excel Discussion (Misc queries) | |||
INDEX & MATCH functions | Excel Worksheet Functions | |||
Index and Match Functions | Excel Programming |