+ Reply to Thread
Results 1 to 3 of 3

TWo Way cross reference formula works but not across entire data range

  1. #1
    Forum Contributor
    Join Date
    11-09-2007
    Location
    USA
    MS-Off Ver
    2003
    Posts
    141

    TWo Way cross reference formula works but not across entire data range

    I have attached a sample of the issue. The formula is found in cell B49. If I enter a gravity of 2.76 or higher in cell B47 I get #N/A in cell B49. Why will it not read any farther over than 2.75. I have been starring at this for awhile now. I might look pretty dumb after someone else looks at it. Any suggestions? Thanks.
    Attached Files Attached Files
    Last edited by ge0rge; 05-22-2009 at 09:12 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,061

    Re: TWo Way cross reference formula works but not across entire data range

    If you reenter 2.76 at AB1 it works.

    Looks like AB1, AC1 onwards have values of 2.75999999999 not 2.76
    This starts from cell X1 onwards, check the whole of row one, your values look skewy
    Last edited by Special-K; 05-21-2009 at 01:52 PM.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    11-09-2007
    Location
    USA
    MS-Off Ver
    2003
    Posts
    141

    Re: TWo Way cross reference formula works but not across entire data range

    That is very odd..thank you though.

+ Reply to Thread

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