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.