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