+ Reply to Thread
Results 1 to 5 of 5

Trying to auto-populate based on if one column matches data from another table

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    Brookville, PA
    MS-Off Ver
    2013
    Posts
    3

    Trying to auto-populate based on if one column matches data from another table

    So, I canít figure out how to make this work.

    I need Column "F" on sheet 2 to show the value of Column "I" on sheet 1 when column "A" on sheet 2 matches column "J" on sheet 1 ; columns "I" and "J" on sheet 1 coincide with different values.

    Something like a combination of the following; sheet2!A:A=sheet1!J:J "then" sheet2!F:F=sheet1!I:I.....

    Just don't know how to write it...

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,393

    Re: Trying to auto-populate based on if one column matches data from another table

    Sounds like you're looking for an index/match sort of thing. What do you want to happen if the value in A (sheet2) isn't in J (sheet1), "N/A", blank, some other value?
    ChemistB
    My 2Ę

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    07-21-2014
    Location
    Brookville, PA
    MS-Off Ver
    2013
    Posts
    3

    Re: Trying to auto-populate based on if one column matches data from another table

    It is all based on work-center numbers and their hourly billing rate. I really wouldn't need it to specify.

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,393

    Re: Trying to auto-populate based on if one column matches data from another table

    So assuming that will never happen and you're looking for exact matches

    =INDEX(Sheet1!$I$2:$I$500, MATCH(A2, Sheet1!$J$2:$J$500,0))

    If this isn't working, try attaching a workbook showing what you have (Go Advanced>Manage Attachments)

  5. #5
    Registered User
    Join Date
    07-21-2014
    Location
    Brookville, PA
    MS-Off Ver
    2013
    Posts
    3

    Re: Trying to auto-populate based on if one column matches data from another table

    Genius! Problem solved! I will be able to edit my exact column values...but that is the formula that I needed.
    Thanks!

+ 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. [SOLVED] Auto Populate cell based on auto filter selection from table in same sheet
    By missydanni in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2013, 05:03 PM
  2. Replies: 4
    Last Post: 06-13-2013, 04:42 AM
  3. Auto Populate Two Columns Based On Data Entered Into Another Column
    By aleenah in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2013, 08:37 PM
  4. Replies: 3
    Last Post: 02-28-2012, 11:54 AM
  5. Replies: 2
    Last Post: 06-25-2010, 09:19 AM

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