+ Reply to Thread
Results 1 to 3 of 3

If one cell equals any cell within a specific range, can a corresponding cell be populated

  1. #1
    Registered User
    Join Date
    03-24-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    2

    If one cell equals any cell within a specific range, can a corresponding cell be populated

    Hi

    I am trying to find a formula where if any one of a range of cells equals a nominated cell's value, values from a different range of cells are displayed.

    i.e. If range D2:F2 = H1 then display cells from A2:C2 in cells H2:J2.

    I have included an image in case I haven't been able to articulate this well enough.

    Any help appreciated!

    Thanks

    Capture.JPG

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: If one cell equals any cell within a specific range, can a corresponding cell be popul

    hi jkempton, welcome to the forum. so in your eg, it should not display anything because D2:F2 does not equals to H1? if so, try:
    =IF(COUNTIF($D2:$F2,$H1)=3,A2,"")

    or if just 1 cell in the range is sufficient, then:
    =IF(COUNTIF($D2:$F2,$H1),A2,"")

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    03-24-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: If one cell equals any cell within a specific range, can a corresponding cell be popul

    Thanks for your response.

    H1 = "XXX" as does D2. Basically I need a formula that if the value in H1 is contained in any cell between the range D2:F2 I want it to display the data from the cells A2, B2 and C2.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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