+ Reply to Thread
Results 1 to 9 of 9

Input a value in one cell and fill the next cell with a value associated with that value

  1. 03-20-2013, 09:38 AM #1
    Monkeyfaceseo
    Monkeyfaceseo is offline
    Registered User
    Join Date
    03-20-2013
    Location
    Bolton
    MS-Off Ver
    Office 365
    Posts
    4

    Input a value in one cell and fill the next cell with a value associated with that value

    We have a range of percentages, that need to be included in a formula, ranging from 1-4 (1=40%, 2=10%, 3=7% and 4+=2%). 4+ because anything greater will be classed as 2 percent but we don't need to complicate further so just consider this as 4.

    Basically, I want to type 1 into cell A1 and in B1 it should automatically fill with the 40% value (40), if I input 2 into A1 I want cell B1 to adjust to 10% (10).

    So far I have cells c1, c2 c3 and c4 containing 40, 10, 7 and 2 respectively.

    What formula would I need to make this happen.

    I'm totally rubbish at explaining things so I apologise for any confusion however would really appreciate "sum" help (see what i did there)!

    Thanks

    Alan
    Reply With QuoteRegister To Reply
  2. 03-20-2013, 10:43 AM #2
    micope21
    micope21 is offline
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Input a value in one cell and fill the next cell with a value associated with that val

    Hi

    Welcome to the forum

    Cell B1 =LOOKUP(A1, {0,1,2,3,4}, {"","40%","10%","7%","2%"}) copy down
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".
    Reply With QuoteRegister To Reply
  3. 03-20-2013, 10:45 AM #3
    BB1972
    BB1972 is offline
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Input a value in one cell and fill the next cell with a value associated with that val

    Hi Alan, and welcome to the forum. This section if for introductions only - you should post this query in the Excel General or Formulas section for an answer.

    PS I "C:" what you did there - nice!


    EDIT Whoops - I was certain I was in the "Introductions" section - apologies for any confusion my post may have caused. The welcome stands, nevertheless
    Last edited by BB1972; 03-20-2013 at 10:50 AM. Reason: Wrong forum - ???
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
    Reply With QuoteRegister To Reply
  4. 03-20-2013, 12:28 PM #4
    Kevin UK
    Kevin UK is offline
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Input a value in one cell and fill the next cell with a value associated with that val

    @ BB1972

    To much of this!

    poteen_kno2.jpg
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)
    Reply With QuoteRegister To Reply
  5. 03-20-2013, 05:50 PM #5
    BB1972
    BB1972 is offline
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Input a value in one cell and fill the next cell with a value associated with that val

    @ Kevin - I think you mean not enough?! Everything seems so strange when I'm sober....
    Reply With QuoteRegister To Reply
  6. 03-21-2013, 05:43 AM #6
    Monkeyfaceseo
    Monkeyfaceseo is offline
    Registered User
    Join Date
    03-20-2013
    Location
    Bolton
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Input a value in one cell and fill the next cell with a value associated with that val

    Sorry for the posting in the wrong area but....

    The good news is it's done now and the results are great thanks to everyone for your help and input truly appreciated!

    Alan
    Reply With QuoteRegister To Reply
  7. 03-21-2013, 10:09 AM #7
    BB1972
    BB1972 is offline
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Input a value in one cell and fill the next cell with a value associated with that val

    Hi Alan,

    Apologies again for any confusion I may have caused you - you did not post in the wrong forum, I just got my wires crossed. Glad to hear you're sorted, though.
    Reply With QuoteRegister To Reply
  8. 03-21-2013, 10:40 AM #8
    Monkeyfaceseo
    Monkeyfaceseo is offline
    Registered User
    Join Date
    03-20-2013
    Location
    Bolton
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Input a value in one cell and fill the next cell with a value associated with that val

    Thanks Brendan, I'm currently trying to embed my end result onto my site (but it's currently playing up) but I will post once done so those who helped can see it in action.

    Cheers

    Al
    Reply With QuoteRegister To Reply
  9. 04-19-2013, 07:01 AM #9
    Monkeyfaceseo
    Monkeyfaceseo is offline
    Registered User
    Join Date
    03-20-2013
    Location
    Bolton
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Input a value in one cell and fill the next cell with a value associated with that val

    Thanks for the help with this. Just realised I got it sorted and never posted the link.

    It's called the OWTET. It's a tool for working out the percentage/numbers of clicks that a website will get depending on its position on Google.

    http://www.monkeyfaceseo.co.uk/seo-s...on-tool-owtet/

    Thanks for the help peeps!

    Al
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1