Results 1 to 8 of 8

How do I use Data Validation and Index Match

Threaded View

  1. #1
    Registered User
    Join Date
    05-25-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    How do I use Data Validation and Index Match

    Good morning.

    I am hoping you can help me with a formula I am struggling with. I am creating a cost calculator to make my clients lives a little easier. An example of what I need would be as follows:

    I have a data validation list for the client to choose their entertainment requirements the list it cell links to is:

    Please Select
    None £0.00
    Pianist £150.00
    Disco £275.00
    Murder Mystery £550.00
    Two Table Casino £450.00
    Three Table Casino £600.00
    Three Piece Band £650.00
    Four Piece Band £800.00
    Five Piece Band £950.00

    Each of these items has a cash value that I have listed in the adjacent cell to the list. I need excel to recognize that when they choose Disco (for example) the results cell will show £275.00. I have tried using MATCH and IF functions but cannot work out how to do it.

    I apologise that my first post is asking for help but any assistance you can provide would be greatly appreciated. I am more than happy to email the spreadsheet for you to play with if that helps (attached)
    Attached Files Attached Files
    Last edited by MattyD1978; 05-25-2010 at 06:44 AM. Reason: Changed title to correctly reflect 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