#N/A in approximate match VLOOKUP (with Dates)

[Kwesi Quartey]

Hi Everyone 

I'm just going crazy here with about this Vlookup again and again on this report I'm trying to do. 

I have attached a spreadsheet. 

I'm am using a vlookup on the table, I'm trying to use the "Cycle Date" in the first column to return are the result in the second column "Cycle Date". while looking through "Workings (Cycle Dates)"

the formula seems to work form some the cells, but I still cant figure it out it is not working for all of them. 

Cycle Date	Cycle Date	Workings (Cycle Dates)
29/03/2020	#N/A	29/09/2017	29/09/2017 - 28/10/2017	Oct-17
29/03/2020	#N/A			Nov-17
29/01/2020	29/01/2020 - 28/02/2020	29/10/2017	29/10/2017 - 28/11/2017	Nov-17
29/01/2020	29/01/2020 - 28/02/2020

[#2]

@Kwesi Quartey 

In your formulas you use EXACT match, not approximate one =VLOOKUP(A2,C:D,2,0). Please note for approximate match lookup array shall be sorted.

[#3]

@Sergei Baklan Hi Sergei, sorry I had made a typo. yes, you are correct I'm using an EXACT match not an approximate one. 

[#4]

@Kwesi_Quartey 

For the exact match formula returns correct results.

[#5]

@Sergei Baklan thanks, but I'm still getting "N/A" in some of the fields, which shouldn't be. I've looked some of the old reports and they don't have it. maybe it's me or I don't seem to understand what it is.

[#6]

@Kwesi_Quartey 

An error is only for one date

which is not in the list

[#7]

@Sergei Baklan hmmm, thanks again. I think there's an oversite on my side. let me try and figure this out.