+ Reply to Thread
Results 1 to 5 of 5

Vlookup Indirect function working for Apple Numbers and Google Docs but not Excel

  1. #1
    Registered User
    Join Date
    04-12-2015
    Location
    LAIKIPIA, KENYA
    MS-Off Ver
    2007
    Posts
    13

    Vlookup Indirect function working for Apple Numbers and Google Docs but not Excel

    I am having a simple translation problem with excel. I have made a calculator in Apple Numbers but when I export an csv excel file the function stops working and so too do the dropdowns. I will be able to figure out how to make dropdowns but its my basic problem with the function that i will need help with.

    Basically I have three kinds of safari accommodation that range in price according to the number of people . i have made a calculator that with drop downs allows users to choose the kind of accommodation. The vlookup is then supposed to use a second dropdown that gives number-of-people-options to look up the price from a table. I managed to get the function to work in google docs also using a slightly different dialect but when i output the file from google docs it also does not play nice with excel. Basically the function is in the first cell of the results sheet.

    Here is what the calculator looks like in Apple Numbers:

    calculater.jpg

    And here is the calculator working on google docs:

    https://docs.google.com/spreadsheets...it?usp=sharing

    If someone can offer me a clue for how to speak excel I would be most grateful. Thanks, Jamie in Kenya

    I have attached the not working excel file that was output by numbers for what its worth.
    Attached Files Attached Files

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,296

    Re: Vlookup Indirect function working for Apple Numbers and Google Docs but not Excel

    I downloaded your Google file as Excel and it looks nothing like the Excel file you attached. My comments are related to the Excel file as I downloaded it.

    In tab Calculator, cell B9, you have this formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I do not know why Google is happy with this but in Excel, you must use single quotes to enclose sheet names that include spaces. Use this formula instead:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    04-12-2015
    Location
    LAIKIPIA, KENYA
    MS-Off Ver
    2007
    Posts
    13

    Re: Vlookup Indirect function working for Apple Numbers and Google Docs but not Excel

    Thanks Jeff. I pasted in your formula but im still having some trouble. i suspect Im still no referencing the data in the sheets right in the indirect.

    I have attached the excel file with the formula in it but also a screen shot which might showcase my mistake just as easily. thanks again for your trouble

    cheers, jamie20%ContractRates.xls

    excel-test-(1).jpg

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,296

    Re: Vlookup Indirect function working for Apple Numbers and Google Docs but not Excel

    Your formula uses B4 to hold the name of the sheet containing the lookup table, but B4 is blank.

    Like I said, this file is completely different than the one I get when I go to Google Docs and export it to Excel. That is the problem.

  5. #5
    Registered User
    Join Date
    04-12-2015
    Location
    LAIKIPIA, KENYA
    MS-Off Ver
    2007
    Posts
    13

    Re: Vlookup Indirect function working for Apple Numbers and Google Docs but not Excel

    Jeff, Sorry I was working on another machine that did not have Excel but now I have managed to get to a computer with excel and I have edited the formula in

    'MOTHER - RESULTS'!A2

    to reflect the changed cells from the Google File to the Excel File. It is I think in the sheet reference now that I'm having trouble currently.
    Thanks Jamie20%ContractRates.xls20%ContractRates.xls

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is it possible to use the filter function in Google Docs through Android mobile phone?
    By otterandrews in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-14-2014, 03:00 AM
  2. pull certain data from google docs form-produced spreadsheet to other docs
    By MisterCadillac in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-11-2014, 04:49 AM
  3. Problems with nested IF function in google docs
    By IbbAS in forum Excel General
    Replies: 2
    Last Post: 07-17-2013, 12:02 PM
  4. Query function from google docs in excel 2011, anyone with a solution?
    By emilero in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-12-2012, 04:04 PM
  5. Filter command from Google Docs not working on Excel
    By sakau2007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2010, 12:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1