All solutions INDEX Expert Solution – Excel INDEX Problems

Excel - INDEX Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to use a lookup value that is the result of a formula, (in this case a date) and lookup or match an element in an array (which is a date.. same format as the resultant) and either access the value in the next right cell or use as an index to retrieve it. I have used "=MATCH(C4,Demand,0)" in which C4 is a formula that returns a date in format as an example ... "16-Apr-18" .. and Demand is a series of columns with dates in the same format and sequenced .. I get "#N/A" .. not the value I need and there is an exact date match in the lookup array ....
Solved by V. L. in 23 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 13/04/2018 - 01:20
hello
User 13/04/2018 - 01:21
hello
User 13/04/2018 - 01:21
version 2010
Excelchat Expert 13/04/2018 - 01:21
please share the file
User 13/04/2018 - 01:21
I have no file that works
User 13/04/2018 - 01:21
did you see my comment
Excelchat Expert 13/04/2018 - 01:22
then share the part you are facing problem in the shared view
User 13/04/2018 - 01:23
if I have an array of dates that are sequenced called DEMAND and I have a cell that is a formulae that results in a date (same format as in the array), what either MATCH or VLOOKUP will work as MATCH(c4,Demand,0) returns a #NA
User 13/04/2018 - 01:23
and c4 is a formula
User 13/04/2018 - 01:24
that return a date like "16-Apr-18"
User 13/04/2018 - 01:24
can this be accomplished
Excelchat Expert 13/04/2018 - 01:25
the format problem is occuring for sure
Excelchat Expert 13/04/2018 - 01:25
can yo share the formula which is in c4
User 13/04/2018 - 01:27
B4 > "0apr18" and c4 > c4 + 7
User 13/04/2018 - 01:28
wrong .. B4 > "0apr18" and c4 > b4 + 7
Excelchat Expert 13/04/2018 - 01:28
look here I have showed an example where it is working
Excelchat Expert 13/04/2018 - 01:28
https://docs.google.com/spreadsheets/d/1YpcZESGkJcWwPl_aABEBkskMwwrr8Oq2SPHZOeYjRM0/edit?usp=sharing
Excelchat Expert 13/04/2018 - 01:29
now you can share your formula in c4....which is returning the date....so that we can have a better understanding where you are facing problem
Excelchat Expert 13/04/2018 - 01:29
A1 has the match function
User 13/04/2018 - 01:30
which version are you using
Excelchat Expert 13/04/2018 - 01:30
its actually googlesheet
User 13/04/2018 - 01:31
that is exactly what I have .. and I get #N/A
User 13/04/2018 - 01:31
using 2010
Excelchat Expert 13/04/2018 - 01:31
format error....can you copy an paste all that you have in your sheet in my googlesheet that I shared?
User 13/04/2018 - 01:32
so my thoughts are right and once more MS is working??
User 13/04/2018 - 01:32
sorry . .to stop .. but I must pick up a phone call now ..
Excelchat Expert 13/04/2018 - 01:32
yes concept is right
Excelchat Expert 13/04/2018 - 01:33
But the format between c4 and demand is not right I guess
Excelchat Expert 13/04/2018 - 01:33
may be c4 is returning text instead of date format

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc