+ Reply to Thread
Results 1 to 2 of 2

If beginning three characters in cell = characters found in range then...

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    Aalborg
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    20

    If beginning three characters in cell = characters found in range then...

    Hi,

    I have different item-numbers with recurring prefixs (21-*****, 11-*****, 32-***** etc.) in one column and a value assigned to that prefix in another.
    I want to read the prefixes and divide another number based on the belonging value.

    If item-number starts with the prefix then calculate divide number/value in range corresponding to prefix.

    Is it a LOOKUP or array-formula I should use?

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    26,938

    Re: If beginning three characters in cell = characters found in range then...

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Weird characters at beginning of cell
    By jdelcour in forum Excel General
    Replies: 3
    Last Post: 07-18-2006, 01:55 PM
  2. [SOLVED] How do I eliminate spaces/characters from the beginning of a cell
    By Biff in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  3. [SOLVED] How do I eliminate spaces/characters from the beginning of a cell
    By Biff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  4. How do I eliminate spaces/characters from the beginning of a cell
    By A Waller in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. [SOLVED] How do I eliminate spaces/characters from the beginning of a cell
    By A Waller in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. How do I eliminate spaces/characters from the beginning of a cell
    By A Waller in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. [SOLVED] How do I eliminate spaces/characters from the beginning of a cell
    By A Waller in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. How do I eliminate spaces/characters from the beginning of a cell
    By A Waller in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-29-2005, 06:05 PM

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