Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 12th 19, 11:34 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 21
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

  #2   Report Post  
Old April 13th 19, 08:30 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,696
Default 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!D264)


Regards
Claus B.
--
Windows10
Office 2016


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
INDEX MATCH Functions in LibreCalc (Excel) - Non unique valuesreturn wrong index result io Excel Worksheet Functions 0 February 23rd 13 09:08 AM
Index and Match functions I think Jim Butler New Users to Excel 9 November 25th 08 02:34 AM
Row, Index, Match functions Christopher Naveen[_2_] Excel Discussion (Misc queries) 1 September 20th 07 08:42 AM
INDEX & MATCH functions Iriemon Excel Worksheet Functions 2 August 28th 07 03:50 PM
Index and Match Functions amirstal Excel Programming 1 December 7th 06 04:43 PM


All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017