problem with named range and LOOKUP
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: problem with named range and LOOKUP

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Lincolnshire.UK
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    hi, hope someone can tell me why I'm getting the #NA value on this worksheet, urgently please as I'm got exams Monday


    MEMBERSHIP TYPE FULL YEAR HALF YEAR SWIMMING CARDIO
    MEMBERSHIP FEES 450 250 100 150

    ADMIN CHARGE 20


    NAME MEMBERSHIP TYPE PAID OWING
    PETER FULL YEAR 470 0
    JOHN HALF YEAR 270 0
    GRAHAM HALF YEAR 270 0
    CHRIS HALF YEAR 170 100
    LOO CARDIO 250 #N/A
    SAM FULL YEAR 470 0
    LUKE HALF YEAR 270 0
    SWIMMING 120 0



    [ This Message was edited by: blossom on 2002-04-13 05:02 ]

  2. #2
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    799
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The VLOOKUP formula in OWING column cannot find the corresponding value in data list.

    What is the OWING column function and also data list where it picks the values.

    More info required to give exact answer

    However you can check this link for VLOOKUP usage:

    http://www.thewordexpert.com/excel.h...DreadedVlookup

    Regards

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Lincolnshire.UK
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Many thanks, the link had what I was looking for.

  4. #4
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    799
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Nice to hear that.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com