Help with numbers!!!

Discussion in 'iWork Forum' started by RickH, Apr 18, 2011.

  1. RickH

    RickH
    Expand Collapse
    iPF Noob

    Joined:
    Apr 18, 2011
    Messages:
    1
    Thanks Received:
    0
    I am putting together a spreadsheet using numbers on my very first ipad (2) EVER! I have been using Microsoft FOREVER (first time with a MAC of any kind). This one equation is KILLING ME. Here is what I am trying to do.

    I am a personal trainer and I track peoples weight. So, I have a column of cells that reflects the changes in their weight going from top to bottom. At the very bottom I have a cell that I want to show the "last number in the series of those weigh ins" i.e. each time I add a weight in an empty cell (of the progression) I want it to show up in that bottom cell. If you need a photo image I will be happy to send one. That's all. Very simple. The excel formula is using LOOKUP and a series of symbols and row/cell locations and works perfect. I feel like LOOKUP is what I want but what in the world do I use when all I have to work with is tabs that say "Search for" "search where" and "result-values". PLEASE help! I know there is a formula to do this. Thanks

    Rick
     
    #1 RickH, Apr 18, 2011
    Last edited: Apr 18, 2011
  2. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,450
    Thanks Received:
    4,307
    Banged my head against it for a while, but didn't get anywhere. I may try again later when my head stops hurting. :(
     
  3. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,450
    Thanks Received:
    4,307
    Ok, I still don't understand most of how this works, but the OS X version of Numbers has a weight tracking template that does what you want. I exported it to the iPad, and the formula still worked. If you look over the formula they use maybe you can tweak it to work on your spreadsheet.

    Here's a link to download the file: http://dl.dropbox.com/u/17742163/weight.numbers
     
  4. jakerich

    jakerich
    Expand Collapse
    iPF Novice

    Joined:
    Aug 12, 2010
    Messages:
    31
    Thanks Received:
    0
    But, to do what you asked, double tap on the cell into which you want to put the formula. A window will open, tap the "=" on the bar above the keys, then tap the "functions" button, then "reference" and you will see Lookup as a function you can use.

    Teach a man to fish, etc, etc, etc.
     
  5. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,450
    Thanks Received:
    4,307
    I'm pretty sure the OP knows the function is there. They just couldn't decipher the use instructions. Neither could I. I spent quite a bit of time trying to use the LOOKUP function, but could not make it work as suggested. The formula that works in the Pages example uses different functions in combination with an IF statement. I think I understand it, but haven't looked up all the functions used to make sure.
     
    #5 twerppoet, Apr 18, 2011
    Last edited: Apr 18, 2011
  6. jakerich

    jakerich
    Expand Collapse
    iPF Novice

    Joined:
    Aug 12, 2010
    Messages:
    31
    Thanks Received:
    0
    Perhaps he did know the function is there, but he said, 'all I have to work with is tabs that say "Search for" "search where" and "result-values".' To me that statement shows that he didn't realize a double-tap on the target cell opens up a greater set of choices. If you tap the cell once, that's what you get, you have to tap twice to get to the functions. But in either case, he now has options. It's all good!
     
  7. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,450
    Thanks Received:
    4,307
    I thought the same as you, until I looked up the LOOKUP function and realized what he was calling tabs were actualy the names of the parameters for the function, something I probably would not have noticed if I had not got curious and tried to set up a table to use it.

    As you say, no harm, no foul.
     
  8. jakerich

    jakerich
    Expand Collapse
    iPF Novice

    Joined:
    Aug 12, 2010
    Messages:
    31
    Thanks Received:
    0
    Yep, you are right! I got it backwards. My apologies for questioning your inerrant intuition!
     
  9. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,450
    Thanks Received:
    4,307
    More like stubborn and pedantic. :) No apologies necessary.
     
  10. Scavenger123

    Scavenger123
    Expand Collapse
    iPF Noob

    Joined:
    Oct 24, 2010
    Messages:
    5
    Thanks Received:
    0
    Large Spreadsheet test request

    I am looking for someone to test a large (about 12mb) Excel spreadsheet on the Ipad 2 that was too large for the original Ipad. I was considering Docs to Go but really do not care which app.
     

Share This Page



Search tags for this page
help numbers ipad
,
help with numbers for ipad
,

how to do a lookup function in numbers for ipad

,
how to do a table reference in ipad numbers
,
ipad numbers if statement
,
ipad numbers weight tracker
,

lookup function in numbers

,
rajk formula tutorial for iwrks numbers on the ipad
,
test for a non blank cell in apple numbers tutorial ipad
,
wieght tracker in apple numbers using template