Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Todd
 
Posts: n/a
Default index, match formula

Help, my index formula returns data from the row above the match? What did I
do wrong?

=INDEX('Labor Hours'!B:B,MATCH(B11,'Labor Hours'!A:A,7),1)

The match is on row B:1214 but the data is pulled from B:1213 instead.

Thanks,


Todd



  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default index, match formula

In the MATCH function, match_type (last paramter) should be -1, 0 or 1 and
you have 7! For exact match set to 0.

=INDEX('Labor Hours'!B:B,MATCH(B11,'Labor Hours'!A:A,0),1)

HTH


"Todd" wrote:

Help, my index formula returns data from the row above the match? What did I
do wrong?

=INDEX('Labor Hours'!B:B,MATCH(B11,'Labor Hours'!A:A,7),1)

The match is on row B:1214 but the data is pulled from B:1213 instead.

Thanks,


Todd



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 Formula LJoe Excel Worksheet Functions 2 June 22nd 06 06:19 PM
Help with formula statament with a MATCH. DaveO Excel Worksheet Functions 0 February 22nd 06 04:17 PM
lookup? Index? match? formula Richard Excel Discussion (Misc queries) 4 February 22nd 06 02:50 AM
Index and Match Array formula Graham Haughs Excel Worksheet Functions 4 February 16th 06 02:51 AM
need help with Index, Match and Countif in the same complicated formula HGood Excel Discussion (Misc queries) 0 February 3rd 05 06:34 PM


All times are GMT +1. The time now is 11:10 AM.

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

About Us

"It's about Microsoft Excel"