View Single Post
  #1   Report Post  
Old April 12th 19, 11:34 PM
Gene Haines Gene Haines is offline
Junior Member
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 20
Default 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