Results 1 to 3 of 3

Vlookup, IF, or something better?

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2009
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    75

    Vlookup, IF, or something better?

    Hello,

    I'm trying to figure out what function (or set of) would be best for my task. I need to create a spreadsheet with minimal user-input. Column A will have a list box via data verification and everything else will be locked and filled in through functions by taking data from another sheet. I've created an example of what I'm trying to accomplish and it's attached.

    The user will select an option in column A, here "Drinks." Doing so will fill in the data in the columns to the right automatically. My list options in the final document will be fairly extensive, so using IF statements might get pretty crazy. I'm sure there is a more efficient way to handle this. I'm thinking VLookup might be my best route?

    Thanks for your time!
    Attached Files Attached Files
    Last edited by thesonofdarwin; 04-14-2010 at 09:46 PM.

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