Forum Discussion
Kwesi Quartey
May 05, 2020Copper 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 have attached a spreadsheet. I'm am using a vlookup on the table, I'm trying ...
Kwesi_Quartey
May 05, 2020Copper Contributor
SergeiBaklan Hi Sergei, sorry I had made a typo. yes, you are correct I'm using an EXACT match not an approximate one.
SergeiBaklan
May 05, 2020Diamond Contributor
For the exact match formula returns correct results.
- Kwesi_QuarteyMay 05, 2020Copper Contributor
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.
- SergeiBaklanMay 05, 2020Diamond Contributor
- Kwesi_QuarteyMay 05, 2020Copper Contributor
SergeiBaklan hmmm, thanks again. I think there's an oversite on my side. let me try and figure this out.