Circular Cell Ref.?
Circular Cell Ref.?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Circular Cell Ref.?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi folks
    I'm getting majorly wracked off as a vlookup i'm attempting keeps returning true for certain codes & not the figure that i know is there. Does this have something to do with the above?, and if so how do i stop it?

    Cheers
    Matt

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    what's your formula dude ?

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    back to top if you still need help..

    fix i suggest is add col ie one to right and copy/ drag formula.. no circul athem

    Cir cell is just you have refered to a cell thats involve the calculation.. it cant add or times by its self and return a result in its self..kinda in side out.

    im rubbish at english i know but thats not so bada.

    dam i read that and im english!

    i need education FAST!

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

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