+ 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
    46

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,417

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    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