Solved

Index Match

Posted on 2016-08-29
7
49 Views
Last Modified: 2016-08-30
Hello,

I cant seem to get the total for the particular date.
Its better to see the attached excel.  

I want to display the number in a cell on another sheet using Index and Match.  

Please see attached for a better idea.
EEqstn.xlsx
0
Comment
Question by:pdvsa
  • 3
  • 2
  • 2
7 Comments
 
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41775773
Shouldn't it be like this?
=INDEX(Data!9:9,MATCH(C2,Data!3:3))
0
 
LVL 33

Assisted Solution

by:Rob Henson
Rob Henson earned 250 total points
ID: 41775927
Further to Neeraj's comment, to get an exact match on the date use:

=INDEX(Data!9:9,MATCH(C2,Data!3:3,0))

Omitting the last argument may return the wrong value if an exact match on the date is not found.

You could also use SUMIF function:

=SUMIF(Data!3:3,$C$2,Data!9:9)
0
 

Author Comment

by:pdvsa
ID: 41776153
HI guys, if I use the Index:  =INDEX(Data!9:9,MATCH(C2,Data!3:3)) and Robs as well.
the date that it returns is like this:  1/0/1900?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 33

Expert Comment

by:Rob Henson
ID: 41776202
Try changing the cell format.

Excel will try and format a cell based on the source cells and will occasionally do it incorrectly.
0
 
LVL 30

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 250 total points
ID: 41776211
Please refer to the attached.
EEqstn.xlsx
0
 

Author Closing Comment

by:pdvsa
ID: 41776245
Perfect!  thank you both....
0
 
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41776250
You're welcome. Glad we could help.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question