+ Reply to Thread
Results 1 to 7 of 7

lookup formula error in new office version

  1. #1
    Registered User
    Join Date
    10-03-2019
    Location
    South Africa
    MS-Off Ver
    Office 2019
    Posts
    3

    lookup formula error in new office version

    hi,

    i am working with dates and times with lookup formula, which worked fine but after the new upgrade to new office, the formula goes all wrong only in certain cells. is there maybe a setting that needs to change? please help!!!!!
    Last edited by Maleficent01; 10-04-2019 at 02:39 AM.

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,042

    Re: Hi

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  3. #3
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,042

    Re: Hi

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  4. #4
    Registered User
    Join Date
    10-03-2019
    Location
    South Africa
    MS-Off Ver
    Office 2019
    Posts
    3

    Re: lookup formula error in new office version

    see example attached. sheet 1 is without formula, which is supposed to be the end result. sheet 2 is when formula goes haywire.
    Attached Files Attached Files

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    22,760

    Re: lookup formula error in new office version

    Where's the problem? Both sheets look the same to me!!
    Glenn



  6. #6
    Registered User
    Join Date
    10-03-2019
    Location
    South Africa
    MS-Off Ver
    Office 2019
    Posts
    3

    Re: lookup formula error in new office version

    Hence my question the first time, is there maybe a setting that needs to be changed? i have upgraded to the new microsoft office 365 proplus. Before the upgrade, the formula worked fine. Other colleagues with older versions don't seem to have an issue with this formula.

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    22,760

    Re: lookup formula error in new office version

    Ah, Sorry, my mistake!!

+ 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