help on vlookup

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: help on vlookup

  1. #1
    Board Regular
    Join Date
    Apr 2014
    Posts
    201
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default help on vlookup

     
    I have the following formula, but it is not working because column C from Database is also a formula.

    =VLOOKUP(D4522,'T:\Version 10\[Backlog Template for v.10.0.xlsx]Database'!$C:$S,17,0)

    For what its worth Column C in Database is formatted as number and needs to be retained that way.
    Always be GOOD.....
    If you can't be GOOD, be CAREFUL....

  2. #2
    Board Regular
    Join Date
    Nov 2015
    Location
    United States: Portland, OR
    Posts
    366
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: help on vlookup

    You should still be able to look up a value if there is a formula creating it. Can you check something for me? Tell me the two results of these two formulas:
    =TYPE(D4522)
    =TYPE('T:\Version 10\[Backlog Template for v.10.0.xlsx]Database'!$C2)

    Change C2 to a cell that contains a value in column C in the database.

    There may be an issue with the underlying data type of these values, causing the lookup function to fail.

  3. #3
    Board Regular
    Join Date
    Apr 2014
    Posts
    201
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: help on vlookup

    here you go


    =TYPE(D4522)
    ~~~~ 1
    =TYPE('T:\Version 10\[Backlog Template for v.10.0.xlsx]Database'!$C2) ~~~ 2
    Always be GOOD.....
    If you can't be GOOD, be CAREFUL....

  4. #4
    Board Regular
    Join Date
    Apr 2014
    Posts
    201
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: help on vlookup

    I made it work, I know it is not he correct solution but this is what I did.

    =VLOOKUP(value(D4522),'T:\Version 10\[Backlog Template for v.10.0.xlsx]Database'!$C:$S,17,0)

    I also added value formula on column C
    Always be GOOD.....
    If you can't be GOOD, be CAREFUL....

  5. #5
    Board Regular
    Join Date
    Nov 2015
    Location
    United States: Portland, OR
    Posts
    366
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: help on vlookup

      
    You can always use this too:
    =VLOOKUP(D4522+0,'T:\Version 10\[Backlog Template for v.10.0.xlsx]Database'!$C:$S,17,0)

User Tag List

Tags for this Thread

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