Mac Excel 2008 - vlookup

Discussion in 'Mac Apps and Mac App Store' started by TayHarley, Jun 17, 2010.

  1. TayHarley macrumors member

    TayHarley

    Joined:
    Mar 14, 2008
    #1
    One of my favorite functions doesn't work - really weird. When I get to line 50 of the workbook it stops working !!!! It doesn't matter if I cut n paste, drag or manually input the formulae it just stops ! Every row above row 50 - it works - below 50 ... nope #value appears. So an argument is wrong - but I'm inserting the same argument that works above !!!!

    Is this an Mac Office glitch or am I losing my mind :confused:

    Any advice appreciated . . . Stu


    edit: just realised that if I increase the lookup to row 75 the reference works up to row 75 but not beyond - weird. I can't replicate the problem on MS Office on a pc !
     
  2. TayHarley thread starter macrumors member

    TayHarley

    Joined:
    Mar 14, 2008
    #3
    excellent - thx for the link. I've been noticing a few strange things with Mac Excel, don't even get me started on pivot tables !! thx again . . . Stu
     

Share This Page