Forum Discussion
#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 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 |
6 Replies
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.
SergeiBaklan Hi Sergei, sorry I had made a typo. yes, you are correct I'm using an EXACT match not an approximate one.
For the exact match formula returns correct results.
