Results 1 to 2 of 2

Thread: =Search & =Rank problem

  1. #1

    Angry =Search & =Rank problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello! I'm new to this site, apologies if i'm asking a noob question. But I've been stuck on this one problem I'm experiencing. I'm creating a search in excel and I have a list of accounts (1,800 entries) Name City State Etc.. However in the Name column we are utilizing addresses as names as well as regular customer names; so essentially some cells in the customer name column will have just and address like 19-23 42nd street building then the next cell will be a name of a customer like Mr.Smith Residence. Now when I sttempt to type in the customer name like Mr.Smith or just Mr. it works fine it populates a list, but when I attempt to enter a customer name 18 or 18-23 (number) nothing happens. I used "=search then = rank then =vlookup".............
    Please help! Thank you!

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    Hi dahaze140,

    Can you post a sample workbook showing what you've described?

Posting Permissions

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