+ Reply to Thread
Results 1 to 3 of 3

How to populate cells with data based on conditions from ranges

  1. #1
    Registered User
    Join Date
    10-13-2009
    Location
    Thailand
    MS-Off Ver
    Excel 2007
    Posts
    8

    How to populate cells with data based on conditions from ranges

    What formula do I use to populate certain cells (E5:E10 and J5:10) based on match with condition (E3) with cells from and in the ranges C2:C73 and D2:D73 without creating milelong IF formulas?

    I am almost at the goal... past 10pm here in Thailand and still at the office:-(... Really would appreciate it if someone could help me on this last (I hope) bit.

    Thanks in advance!
    Attached Files Attached Files
    Last edited by dobd; 10-13-2009 at 11:25 AM.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,389

    Re: How to populate cells with data based on conditions from ranges

    Hi,

    I'm not entirely sure what data you want, but this may help. Please let me know.
    Attached Files Attached Files
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    10-13-2009
    Location
    Thailand
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: How to populate cells with data based on conditions from ranges

    Yes, sweep, like that! Thank you very much for your prompt help! And here I was sitting for the last 2 hours poundering over IF formulas covering 3 lines:-( You did it in 5 minutes! Again, Thank you!

+ 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