+ Reply to Thread
Results 1 to 4 of 4

Inserting Values in a Cell Depending on Content in an Adjacent Cell

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Dublin
    MS-Off Ver
    Excel 2010
    Posts
    6

    Inserting Values in a Cell Depending on Content in an Adjacent Cell

    Hi, this is a little more complex than the title but I wasn't able to phrase it succintly enough.

    I have the names of companies in one column, and the amount they owe in cells in the column beside them. I then have a second list of companies that is a subset of the first. Is there a formula that would place the amount they owe in teh corresponding cell adjacent to the compny in the second list? I've attached a sample workbook, Full Company List in column A, amount owing in B, trimmed down list in D and ideally I'd like the corresponding values in E. Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Inserting Values in a Cell Depending on Content in an Adjacent Cell

    if understand this correct, try this in cell E2 and copy down

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    10-17-2013
    Location
    Dublin
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Inserting Values in a Cell Depending on Content in an Adjacent Cell

    Perfect! Thank you very much.

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Inserting Values in a Cell Depending on Content in an Adjacent Cell

    glad I could help and thanks for the rep point....have a great day

+ 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] How to autofill a column with a cell content depending on content in another cell.
    By lul1971 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-17-2012, 12:33 PM
  2. Change ws3 Cell Content Depending On ws1 Content
    By heliskier89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2011, 04:52 PM
  3. Replace cell content- depending on other cell data
    By DEVIL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-06-2009, 07:07 PM
  4. Replies: 11
    Last Post: 07-26-2008, 05:18 AM
  5. [SOLVED] Copy content of cell to another depending on value of third cell(between worksheets)
    By Zeljko Milak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-14-2006, 02:25 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