iPad and numbers vlookup

[pbipadforum]

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

 

[twerppoet]

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)

 

[leelai]

Hi and welcome to the Forum. Enjoy!!

Sent from my iPad using iPF

 

[Gabriel1]

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