Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2003
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    range table is zero (excel97)

    hello there
    Im trying out this solution by using macro (pls see attachment)
    I have done partly thru macro VB but when i run it the result of CCC shows #N/A because it does not have the record for it. What i want is how to show if there is no such record it shld be blank instead of #N/A and if theres a record it will show the value. Pls help
    Thank you <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    nuglorious

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: range table is zero (excel97)

    No need to use VBA. Enter this formula in E9:

    =IF(ISNA(VLOOKUP(E8,$E$15:$F$18,2,0)),"",VLOOKUP(E 8,$E$15:$F$18,2,0))

    and fill right to H9. The ISNA function tests if the result of VLOOKUP is #N/A. If so, return a blank, otherwise the result ot VLOOKUP. The reference to E15:F18 has been made absolute by pressing F4 (witness the $ characters) to make copying the formula to other cells possible.

  3. #3
    Star Lounger
    Join Date
    Apr 2003
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: range table is zero (excel97)

    alright..it works [img]/forums/images/smilies/wink.gif[/img]
    you are really an expert.... <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> I wish i could be like you... <img src=/S/kiss.gif border=0 alt=kiss width=34 height=15>
    Thank you
    <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

Posting Permissions

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