+ Reply to Thread
Results 1 to 4 of 4

Auto-filling corresponding cells based on matching text

  1. #1
    Registered User
    Join Date
    11-04-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Auto-filling corresponding cells based on matching text

    Hi, trying to teach myself Excel but got thoroughly stuck on a particular formula where i'm trying to enter text into a column, then have the next column use that text to fill itself based on defined list.

    Since i'm sure that wasn't very clear, i've attached a small sample of what i'm trying to do. On the right side i'll have a set of defined values which won't change.
    On the left side i have values that i'll input manually, but columns C & D will auto-fill via a formula based on the text in column B.
    So, Example1 is what i would enter manually, Example2 is what it should auto-fill to look like with the appropriate formulas entered for columns B & C.

    I tried the formula
    =IF(EXACT(B4, !K:K), !L:L, "")
    but to no avail...and none of the other formula conditions looked like what i was trying to do.

    Any help would be greatly appreciated, this is clearly over my head.
    Attached Files Attached Files
    Last edited by silat; 11-04-2010 at 09:53 PM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,109

    Re: Formula Help

    You need to use the VLOOKUP function. See attached.

    VLOOKUP takes a value that you want to find (first argument), tries to find it in the first column of a block of data (second argument), then once it finds it, it returns data in the same row in the nth column (third argument). The fourth argument set to FALSE means that your data isn't sorted and you insist on an exact match.

    You can find details if you look it up in Excel Help.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Formula Help

    think this is what you need
    Attached Files Attached Files
    Windows 7 using Office 2007 & 2010

    Remember your [ code ] [ /code ] tags, makes reading soooo much easier

  4. #4
    Registered User
    Join Date
    11-04-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Auto-filling corresponding cells based on matching text

    Much appreciated 6string & scotty, vlookup seems to be what i needed, now i'm off to try implementing it.

    thanks!

+ 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