pdvsa
asked on
Index Match
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
HI guys, if I use the Index: =INDEX(Data!9:9,MATCH(C2,D ata!3:3)) and Robs as well.
the date that it returns is like this: 1/0/1900?
the date that it returns is like this: 1/0/1900?
Try changing the cell format.
Excel will try and format a cell based on the source cells and will occasionally do it incorrectly.
Excel will try and format a cell based on the source cells and will occasionally do it incorrectly.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! thank you both....
You're welcome. Glad we could help.
=INDEX(Data!9:9,MATCH(C2,D