Hi
I'm having a problem using datedif function with Vlookup.
I have a range of cells where I use datedif to calculate a persons age in years and months (6.11 being 6 years and 11 months)
I am then trying to vlookup a value in a table based on the age calculated from datedif.
I keep getting a value not available error #NA. I think the error is due to way the values are shown for the age in the lookup table but I haven't been able to work out how to show they in same details as datedif is answering.
I have attached a sample spreadsheet, my error is in cells named "normal range", which should show a ranged answer based on the calcuated age.
Help
Bookmarks