+ Reply to Thread
Results 1 to 8 of 8

Referencing cells on a separate sheet based on pull down menu response

  1. #1
    Registered User
    Join Date
    06-01-2009
    Location
    Washington, USA
    MS-Off Ver
    Excel Mac v. X
    Posts
    15

    Question Referencing cells on a separate sheet based on pull down menu response

    Hello,
    I have two sheets in my workbook. One is a list ('LIST') of customer names, the products they make, and each products cost.

    The second sheet ('Tally') will be filled in by users. So far I have set them up with data validation to have pull down menus (based on named lists on 'LIST'). Also, have an indirect reference to give users the appropriate list of products based on the customer they select.

    Now, I am trying to figure out how to get the price to automatically fill in based on the product chosen in 'TALLY'.

    Based on what I have looked up, I think it is an "INDEX", but I am not sure of the logic in that formula.

    Any help would be much appreciated.

    PS-
    I have a sample workbook that I tried to attach (manage attachments below) but it won't let me post it - says "error-invalid file". If someone can let me know how to do that properly, I will attach my workbook.

    Thank you!

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Referencing cells on a separate sheet based on pull down menu response

    Quote Originally Posted by Jenrich View Post
    I have a sample workbook that I tried to attach (manage attachments below) but it won't let me post it - says "error-invalid file". If someone can let me know how to do that properly, I will attach my workbook.

    Thank you!
    It has to be a .xls or .xlsx file less than 1,000kb in size.. if it is larger, you can zip it first to less than 9.7Mb
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    06-01-2009
    Location
    Washington, USA
    MS-Off Ver
    Excel Mac v. X
    Posts
    15

    Re: Referencing cells on a separate sheet based on pull down menu response

    It is a .xls file and is less than 1000kb. It still has the same error. I am on a Mac using OS v.X if that makes any difference??

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Referencing cells on a separate sheet based on pull down menu response

    I am not sure if that makes a difference.. I doubt it should.

    Try zipping it anyways...

  5. #5
    Registered User
    Join Date
    06-01-2009
    Location
    Washington, USA
    MS-Off Ver
    Excel Mac v. X
    Posts
    15

    Re: Referencing cells on a separate sheet based on pull down menu response

    Ahh, zipping it looks like it worked. Here is the attachment.

    Thanks!
    Attached Files Attached Files

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Referencing cells on a separate sheet based on pull down menu response

    I only see a text file in there....

  7. #7
    Registered User
    Join Date
    06-01-2009
    Location
    Washington, USA
    MS-Off Ver
    Excel Mac v. X
    Posts
    15

    Re: Referencing cells on a separate sheet based on pull down menu response

    Well, shoot... When I click on the link I see on the forum it opens the excel file. I just compressed my original file and attached that one. I am at a loss... what else can I try?

    Thanks for your patience.
    -Jen

  8. #8
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Referencing cells on a separate sheet based on pull down menu response

    It is probably the Mac thing then.... maybe try uploading to a hosting site like Google Docs

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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