Mac Excel 2008 - vlookup

[TayHarley]

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

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 !

 

[iSaint]

A quick Google search brought up this article. Maybe it'll be helpful.

http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/d992c711ffe1a01f

 

[TayHarley]

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