+ Reply to Thread
Results 1 to 3 of 3

2003 Compatibility

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Kingston, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    2

    2003 Compatibility

    Hello there,

    I'm currently using Excel 2010, but I have a spreadsheet that's not working for those using Excel 2003 due to some functions that are too new for it.

    In particular I'm trying to figure out a way to make this work:

    =IF(ISBLANK(F6),"",IFERROR(VLOOKUP(F6,'Master Data'!A:B,2,FALSE),"Not Available."))


    I've done some googling and IFERROR seems to be the problem. Apparently there is an ISERROR formula that is compatible with 2003, but I've been unable to make it work.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,698

    Re: 2003 Compatibility

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    Kingston, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: 2003 Compatibility

    That worked.

    Thank you very much Sixthsense! It is very much appreciated.

+ 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