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