+ Reply to Thread
Results 1 to 5 of 5

Set number value displayed in cell when certain text value is displayed in another

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2013
    Posts
    14

    Set number value displayed in cell when certain text value is displayed in another

    Hello,

    I'm sure the answer for this is somewhere on a forum, but I can't seem to find it. I'm sure it's easy if you know how.

    There are a couple of things I need this to work for, but the basic idea is this...

    I have set up a spreadsheet for a number of shows in different venues. In my C column is the name of the venue, selectable by a drop-down box.

    In my D column I have the venue capacity. I would like this to be automatically filled when I select the venue in column C. e.g. If I have two venues, 'Jo's Bar' (capacity 200) and 'The Hippodrome' (capacity 1000), when I select Jo's Bar in column C, column D automatically displays '200'.

    Thanks for any help!

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Set number value displayed in cell when certain text value is displayed in another

    hi
    try this =IF(C5="Jo's Bar",200,IF(C5="The hippodrome",1000,0))

  3. #3
    Registered User
    Join Date
    06-18-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2013
    Posts
    14

    Re: Set number value displayed in cell when certain text value is displayed in another

    great, thanks!

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Set number value displayed in cell when certain text value is displayed in another

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    Registered User
    Join Date
    06-18-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2013
    Posts
    14

    Re: Set number value displayed in cell when certain text value is displayed in another

    Actually, I have a further question... What happens if I have more venues? I have at least 8? I can't seem to get the formula to work over a larger number...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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