+ Reply to Thread
Results 1 to 3 of 3

Based on Entry Another Cell is Populated with a Value

  1. #1
    Forum Contributor
    Join Date
    11-23-2013
    Location
    La Crosse, Wi
    MS-Off Ver
    Excel 2010
    Posts
    104

    Based on Entry Another Cell is Populated with a Value

    Based on an entry in a cell (either La Nina, Neutral, or El Nino), I want a numeric value to be populated in another cell in my spreadsheet. This will allow me to do further calculations. In this basic example, my entry cell is Cell I3 where either La Nina, Neutral, or El Nino will be entered. If cell J2 is La Nina, cell I3 will be populated with -0.5 (now this will change with some other cells in my spreadsheet). If cell J2 is Neutral, cell I3 will be populated with 0. If cell J2 is El Nino, cell I3 will be populated with 0.5. I tried doing a series of If Then statements, but get #VALUE! Here is my equation...

    =IF(I3=E3,-0.5),IF(I3=E4,0),IF(I3=E5,0.5)

    If there is a better way of doing multiple selections, please let me know.

    Thanks in Advance!

    Jeff B
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Based on Entry Another Cell is Populated with a Value

    Try this...
    =VLOOKUP(I3,E3:F5,2,0)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Based on Entry Another Cell is Populated with a Value

    by the way, your formula would work this way...
    =IF(I3=E3,-0.5,IF(I3=E4,0,0.5))

+ 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: 1
    Last Post: 01-04-2021, 04:51 PM
  2. Replies: 2
    Last Post: 04-18-2019, 04:08 PM
  3. Replies: 11
    Last Post: 11-11-2017, 12:12 AM
  4. Replies: 11
    Last Post: 01-23-2017, 11:40 AM
  5. Replies: 5
    Last Post: 09-28-2016, 07:02 PM
  6. Replies: 4
    Last Post: 03-21-2014, 12:01 AM
  7. Drop-down populated based on whether cell is blank or not
    By ss7745 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2013, 12:04 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