**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.*