iPad and numbers vlookup

Discussion in 'New Member Introductions - Site Assistance' started by pbipadforum, Nov 20, 2011.

  1. pbipadforum
    Offline

    pbipadforum iPF Noob

    Joined:
    Nov 19, 2011
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Hi new to apple and iPad, I hope to use an excel developed file which incorporates some vlookup in the formula. Can'this file be "read" by numbers, i understand that not all formula will be converted. Will I be able to "re-write" easily to restore my excel version
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,003
    Thanks Received:
    2,321
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,801 / 1
    There is a vlookup function in Numbers. Whether this will transfer when you import the Excel sheet, or work properly when it does can't be guaranteed until you try.

    If there is no private or sensitive data in the spreadsheet, I would be happy to import it into Numbers and see what happens. Be sure to tell me what it's supposed to do. I'm not always bright enough to figure it out myself.

    You'll need three more posts before you can supply a link or attachment, so wander around the forum a bit more and participate. I will guarantee it's worth the time. Lots to learn here.

    Numbers has a unique way of entering formulas that may (probably will) confuse those used to Excel. It takes a while to get used to, but works fine. The other quirks and methods of entry on a tablet vs a computer also take a bit of practice, but you'll run into that no matter what spreadsheet app you decide on.

    P.S. Hello, and welcome to the forum. (I always forget that part) :)
  3. leelai
    Offline

    leelai Administrator Staff Member

    Joined:
    Apr 24, 2011
    Messages:
    24,835
    Thanks Received:
    1,290
    Trophy Points:
    113
    Location:
    Brisbane, Australia
    Ratings:
    +1,367 / 0
    Hi and welcome to the Forum. Enjoy!!

    Sent from my iPad using iPF
  4. Gabriel1
    Offline

    Gabriel1 Super Moderator Staff Member

    Joined:
    Mar 11, 2011
    Messages:
    17,098
    Thanks Received:
    747
    Trophy Points:
    0
    Location:
    Cranbrook, Kent, UK
    Ratings:
    +749 / 0
    Hi there and welcome.

    There is lots of good advice and info on here plus plenty of members all too willing to help with any problems.

    Remember, search is your friend.......and please don't forget to read the rules http://www.ipadforums.net/forum-rules-help-info/2119-forum-rules-everybody-please-read.html

    These are the hacking section rules for all you jail breakers (and would be jail breakers) http://www.ipadforums.net/ipad-hacking/2892-hacking-section-rules-please-read.html

    We also have an app for this forum. The link to download the app is: Discussion Forum for iPad Users for iPhone, iPod touch, and iPad on the iTunes App Store

    If you have other Apple products or are interested in other Apple kit then why not join our sister forum too at http://www.appleforums.net/

    Finally, if you still haven't had enough, how about a video explaining about our other forums (note:you may want to play this at half speed but hey, why shouldn't Phil be excited about our forums!)

    The Archangel
    Last edited by a moderator: Jun 23, 2014

Share This Page

Search tags for this page

ipad numbers vlookup

,

vlookup in numbers

,
vlookup in numbers for ipad
,

vlookup numbers ipad

,

vlookup on ipad