+ Reply to Thread
Results 1 to 3 of 3

How to auto-fill text based on Value'8000,8001' in another cell

  1. #1
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    52

    How to auto-fill text based on Value'8000,8001' in another cell

    How to auto-fill text based on Value'8000,8001' in another cell
    Is there formula for this or A VBA line script??

    both will be fine

    If H2 is ''Commision'' on P2 must appear 8000

    Most Names can be the same number

    example
    8000 Back-up Online
    8000 Commissie
    8001 CPU
    8001 sal
    Last edited by Shimazu; 02-17-2014 at 05:01 AM.

  2. #2
    Forum Contributor
    Join Date
    03-28-2013
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    226

    Re: How to auto-fill text based on Value'8000,8001' in another cell

    Place this formula in P2

    Please Login or Register  to view this content.
    Give Feedback and Click(*)

  3. #3
    Registered User
    Join Date
    02-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    52

    Re: How to auto-fill text based on Value'8000,8001' in another cell

    I get a forumle problem with this one

    but i think the line is good hmmmmm

+ 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. Replies: 2
    Last Post: 11-29-2012, 11:27 AM
  2. Replies: 1
    Last Post: 05-06-2010, 03:09 AM
  3. Auto fill a range based on another cell
    By Ricardo9211 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 04:58 PM
  4. [SOLVED] How to auto-fill text based on text in another cell
    By Jason in forum Excel General
    Replies: 2
    Last Post: 02-16-2005, 04:37 PM

Tags for this Thread

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