1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

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:
    15,935
    Thanks Received:
    1,806
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,912 / 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,752
    Thanks Received:
    1,238
    Trophy Points:
    113
    Location:
    Brisbane, Australia
    Ratings:
    +1,282 / 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,132
    Thanks Received:
    746
    Trophy Points:
    0
    Location:
    Cranbrook, Kent, UK
    Ratings:
    +747 / 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

apple numbers vlookup

,
excel lookup on ipad
,
excel to numbers ipad vlookup
,
how to use lookup in numbers on an ipad
,
ipad excel vlookup
,
ipad number app vlookup
,

ipad numbers vlookup

,
ipad vlookup
,
lookup functions ios numbers
,
numbers for ipad error in vlookup
,

numbers ipad vlookup

,
numbers vlookup ipad
,
vlook up on ipad numbers
,

vlookup in numbers

,

vlookup in numbers for ipad

,
vlookup in numbers ipad
,
vlookup ipad numbers
,

vlookup numbers ipad

,

vlookup on ipad

,
will vlookup work on ipad