+ Reply to Thread
Results 1 to 3 of 3

2 worksheets, need to merge and/or match

  1. #1
    Registered User
    Join Date
    11-14-2007
    Posts
    4

    2 worksheets, need to merge and/or match

    I have a worksheet (invoices) that is missing data that I have on another worksheet (acctlist). How do I match the acct # on the invoices worksheet with the account names from worksheet acctlist. Thanks for the help! Attached is a small sample.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    In B2, and copy down:

    =VLOOKUP(A2,acctlist!$A$1:$B$18,2,FALSE)

  3. #3
    Registered User
    Join Date
    11-14-2007
    Posts
    4

    Thanks!

    You saved me again! Thanks so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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