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 ...
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.
SergeiBaklan hmmm, thanks again. I think there's an oversite on my side. let me try and figure this out.