Help with LOOKUP / MATCH on Numbers please

Discussion in 'New Member Introductions - Site Assistance' started by chezlong, Oct 6, 2014.

  1. chezlong

    chezlong
    Expand Collapse
    iPF Noob

    Joined:
    Oct 6, 2014
    Messages:
    4
    Thanks Received:
    0
    Hi,

    Very new to this kind of thing. Using information on here I've been learning my way around Numbers, creating dropdown menus. However, I've been asked to create LOOKUP on Numbers (I can't even do that kind of thing on Excel!) to show the following:
    If A1=XXXX, show options A2=123, A3=12, A4=456 etc
    If A1=YYYY, show options A2=qwe, A3=rty, A4=uio etc

    What formula(s) should I be using? Do I need a new worksheet like I would in Excel with all the possible scenarios on it?

    Any help would be much appreciated.

    Thanks,


    C
     
  2. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,286
    Thanks Received:
    5,822
    Can you describe what you are trying to do in more detail. I'm not sure I understand. Once I'm sure I know what's supposed to happen it will still take me a while to look into it.

    I've use search-like features in Numbers before, as an experiment, but I don't remember enough to offer advice off the top of my head.
     
  3. Victoria022

    Victoria022
    Expand Collapse
    iPad Fan

    Joined:
    Jan 6, 2013
    Messages:
    167
    Thanks Received:
    13
    It's good to have you here. Welcome aboard!!
     
  4. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend II

    Joined:
    Jan 8, 2011
    Messages:
    20,286
    Thanks Received:
    5,822
    You haven't added any details. Did you manage to figure it out yourself?

    I did go back and review the spreadsheet I created using the LOOKUP formula. It was an idea I had about searching a table for songs and getting the album and track number as results.

    Turned out it wasn't practical, but I did figure out how to use LOOKUP, make it work after a fashion. The main reason it doesn't work is the search term needs to be an exact match, or the results are unreliable.
     

Share This Page