Results 1 to 8 of 8

Formula to copy specific data if certain conditions are fulfilled

Threaded View

  1. #1
    Registered User
    Join Date
    02-05-2016
    Location
    Kigali
    MS-Off Ver
    excel 2007
    Posts
    21

    Formula to copy specific data if certain conditions are fulfilled

    Hi guys,

    I have constant related data in column A and column B.
    I want a formula in column E that would look at the value in column D and copy it if it matches a value from column A, if it doesn't match I want it to copy the closest greater value from column A. (Cells D13 & D14 are the only ones matching data from column A).
    I also want a formula in column F to copy a value from column B that corresponds to the value from column A copied to column E.

    In the attached workbook, you'll see how I want column E and F to look like.

    Thanks for your help,

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to retrieve specific data if certain conditions are fulfilled
    By joel.mugabe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2016, 04:52 AM
  2. [SOLVED] Attribute a specific number to a specific cell if conditions are fulfilled
    By joel.mugabe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2016, 10:16 AM
  3. Replies: 1
    Last Post: 09-09-2014, 10:47 AM
  4. [SOLVED] How to fill a cell with formula if condition fulfilled
    By ruliansyah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2013, 05:29 AM
  5. [SOLVED] Copy cell to specific locations based on certain conditions
    By aviatecar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2012, 12:52 PM
  6. Replies: 1
    Last Post: 03-05-2010, 03:00 PM
  7. Choosing a formula to used based on a codition fulfilled
    By The Big Dog in forum Excel General
    Replies: 1
    Last Post: 10-12-2005, 12:05 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