Results 1 to 7 of 7

Vlookup and DatedIf Problem Value not available

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Vlookup and DatedIf Problem Value not available

    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
    Attached Files Attached Files
    Last edited by AmrsDavid; 10-07-2012 at 11:46 PM. Reason: sample attached and working cleaned up

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1