+ Reply to Thread
Results 1 to 8 of 8

Cell validation and if valid display from one cell, if not display from the other cell

  1. #1
    Registered User
    Join Date
    01-21-2014
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    5

    Cell validation and if valid display from one cell, if not display from the other cell

    Hello,

    I have a value in one cell that will change between 0 and 1, and I need in a new cell if the value is 0 copy a value from one cell and if the value is 1 then copy from the other cell.

    Can you please help me on it.

    Thanks in advance.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Cell validation and if valid display from one cell, if not display from the other cell

    Try

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    01-21-2014
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Cell validation and if valid display from one cell, if not display from the other cell

    Thank you very much for the quick response..but unfortunately the above statement isn't working in my case. what I need is
    Untitled.png

    I have D1 as 0 and I need a formula in G2, if I have D1 as 0 I need value of E1 and if I have D1 as 1 I need to have F1 value in G2...but the above mentioned formula is not working in my case.

    Thanks in advance

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Cell validation and if valid display from one cell, if not display from the other cell

    Try this in G2

    =INDEX(E1:F1,D1+1)

  5. #5
    Registered User
    Join Date
    01-21-2014
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Cell validation and if valid display from one cell, if not display from the other cell

    Thank you...but not working

  6. #6
    Registered User
    Join Date
    12-20-2013
    Location
    Malta
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Cell validation and if valid display from one cell, if not display from the other cell

    =if(d1=0,e1,f1)

  7. #7
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Cell validation and if valid display from one cell, if not display from the other cell

    Works for me

    In what way does it not work for you?
    Do you get an error? What error?
    Do you get the wrong result? What result did you actually get? What result did you expect, and why?

    Can you post an actual book?
    Pictures aren't really very helpful.

  8. #8
    Registered User
    Join Date
    01-21-2014
    Location
    Austria
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Cell validation and if valid display from one cell, if not display from the other cell

    Hello all

    =if(A1=0;B1;C1)

    works for me...Thank you all for your support.

+ 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. Replies: 4
    Last Post: 12-16-2013, 06:09 AM
  2. Find and display the last occurance in two columns and display related cell
    By willia97 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2012, 08:14 PM
  3. [SOLVED] How to count multiple cell values & do a validation & display results on a different cell
    By adriandefry in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-03-2012, 09:12 AM
  4. Replies: 1
    Last Post: 08-03-2012, 03:56 AM
  5. Replies: 2
    Last Post: 03-07-2008, 08: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