Results 1 to 7 of 7

Thread: Comparing Account Number

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-28-2013, 05:44 PM #4
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    14
    Hi Charles

    I have set up a Vlookup to ccompare account numbers, but it is not working. The reason it is not working is that the data on the sheets has an ' before the numbers. It would be appreciated if you could amend the formula to incorporate this or set up a macro to remove the ' from the numbers

    Attached please find some sample data
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Comparing Mortgage Loans
    By Flupsie in forum Excel Help
    Replies: 3
    Last Post: 02-20-2020, 11:48 AM
  2. Comparing Numbers When One Is Text Format And The Other Is Number Numeric Format
    By Howardc in forum Excel Help
    Replies: 3
    Last Post: 04-05-2013, 08:24 AM
  3. Log In To Email Account Using VBA
    By Excel Fox in forum Download Center
    Replies: 1
    Last Post: 12-14-2012, 11:59 PM
  4. Complex If Statement needed to Calculate Date Range from Create Account to Stop Accou
    By trankim in forum Excel Help
    Replies: 0
    Last Post: 09-07-2012, 09:10 PM
  5. comparing two list of datas in excel and doing conditional formatting
    By Safal Shrestha in forum Excel Help
    Replies: 4
    Last Post: 07-17-2012, 12:49 AM

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
  •  

Forum Rules