+ Reply to Thread
Results 1 to 3 of 3

V Lookup not working

  1. #1
    Registered User
    Join Date
    10-14-2015
    Location
    NY, USA
    MS-Off Ver
    2007
    Posts
    43

    V Lookup not working

    Hello,

    So I am working on automating or putting in some checks in place for one of my project file. In the actual worksheet there are several tabs and I am basically trying to use a Vlookup or any other formula you guys recommend to ensure that all the accounts in the AFO tab are being captured in the Trial Balance tab.

    Basically the story is the AFO tab is pulled from a ledger system which will capture all the accounts added and deleted, however the trial balance is updated manually which can cause an out of balance whenever a new account is updated.

    I would appreciate your insight and feedback on what the most effective formula can be used. I have attached an example condensed into one tab as an example. As you can see my lookup was not working and i am not sure what i was doing wrong. Thanks once again
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,078

    Re: V Lookup not working

    Not sure what you think you told the VLOOKUP to do, but it is doing what you told it to do!

    Is this what you are expecting (try it)?

    =VLOOKUP(E3,$B:$B,1,FALSE)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,864

    Re: V Lookup not working

    "f3"
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. LOOKUP Function not working?
    By leach_18 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-24-2019, 05:18 AM
  2. V-Lookup Problem not working
    By colegerald38 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-15-2016, 12:37 PM
  3. Lookup not working
    By djarcadian in forum Excel General
    Replies: 2
    Last Post: 05-25-2015, 07:39 PM
  4. Lookup not working
    By penfold in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2012, 11:44 AM
  5. lookup not working
    By dougmorgan in forum Excel General
    Replies: 7
    Last Post: 08-22-2010, 05:30 PM
  6. LookUP <> not working
    By penfold in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-13-2010, 12:52 PM
  7. excel lookup not working
    By Pbrain in forum Excel General
    Replies: 2
    Last Post: 03-20-2009, 07:56 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1