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

Occasional Contributor

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

Hi Everyone

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

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
6 Replies

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

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.

# Re: EXACT in match VLOOKUP (with Dates)

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

# Re: EXACT in match VLOOKUP (with Dates)

For the exact match formula returns correct results.

# Re: EXACT in match VLOOKUP (with Dates)

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

# Re: EXACT in match VLOOKUP (with Dates)

An error is only for one date

which is not in the list

# Re: EXACT in match VLOOKUP (with Dates)

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