+ Reply to Thread
Results 1 to 4 of 4

If I select an option from a drop-down in 1 cell, how do i get it to display specific info

  1. #1
    Registered User
    Join Date
    08-05-2012
    Location
    England
    MS-Off Ver
    MS Office 365 Business
    Posts
    11

    If I select an option from a drop-down in 1 cell, how do i get it to display specific info

    Hi all,

    I'm currently trying to set up a spreadsheet to help me in my cake business.
    My query is, if I select an option from a drop-down list (say 6 cakes) in cell P5, I need it to pull the information from cell T1 and display it in cell Q5.
    Like wise, if I select 12 cakes in cell P5, it needs to pull the info from cell T2 and display it in cell Q5. This is so on for however many batches of cakes I need.

    excel screenshot.jpg

    I tried using an IF function but I don't really have a FALSE test value.
    Can what I am asking be done?

    Any help would be very much appreciated

    Many thanks
    Kate

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    Re: If I select an option from a drop-down in 1 cell, how do i get it to display specific

    Try
    In Q5: =VLOOKUP(P5;S1:T4;2;0)
    and change the S column to values: 6,12, ...
    //Ola


    Use ; or , as formula separator.
    Mark the problem as Solved under the Yellow bar up Top right, under Thread Tools, when you received a solution.
    It saves time, to skip already solved threads.

  3. #3
    Registered User
    Join Date
    08-05-2012
    Location
    England
    MS-Off Ver
    MS Office 365 Business
    Posts
    11

    Re: If I select an option from a drop-down in 1 cell, how do i get it to display specific

    Hmm, it doesn't seem to be working. It returns "Err:509" in the cell. However, it has given me a good starting point to work from so I'll keep tinkering and see if I can get it to work.

    Thanks!

  4. #4
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    Re: If I select an option from a drop-down in 1 cell, how do i get it to display specific

    Sorry I missed you were using OpenOffice :-)
    But sounds like you know how to solve it now.
    If not, just let us know.
    //Ola

+ 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