Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need help with index match functions...inside.. (EXCEL 97)

    Hello..

    I'm using this formula :

    =INDEX('Database'!$B$14:$AO$83,MATCH($H$14,'Databa se'!$B$14:$B$83,0),29)

    the problem is when there is no data in return on the specific cells,
    it will shows #N/A. How can I hide this #N/A from show in my file
    and also will be hide when I print the data..Many thanks

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Need help with index match functions...inside.. (EXCEL 97)

    Lazy Way:

    =IF(ISERROR(INDEX('Database'!$B$14:$AO$83,MATCH($H $14,'Database'!$B$14:$B$83,0),29),,INDEX('Database '!$B$14:$AO$83,MATCH($H$14,'Database'!$B$14:$B$83, 0),29))
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need help with index match functions...inside.. (EXCEL 97)

    Thanks John..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •