+ Reply to Thread
Results 1 to 2 of 2

Need a function similar to sumif for text

  1. #1
    Registered User
    Join Date
    04-20-2005
    Posts
    1

    Question Need a function similar to sumif for text

    I'm trying to create a receipt as a separate tab in a workbook. I want to be able to type a reference number into one cell and have all of the information that is associated with that reference # fill into other cells. So that when I put in ref # 1234, the name, address, etc, of the person whose reference # that is will populate into all of the corresponding fields. I have tried vlookup, hlookup, as well as index, and have been unsuccessful. any advice is appreciated!

  2. #2
    Registered User
    Join Date
    03-02-2005
    Location
    Greenville, SC, USA
    Posts
    41
    How is the data laid out? I would think a lookup would work (H or V) but you would need to make sure that both places have the same format. If you are entering a number into a cell fromated as number or general make sure it is looking up a number and not text with numbers in it (common problem I have seen with lookups).

+ 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