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 |
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 04:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com