+ Reply to Thread
Results 1 to 2 of 2

Combo Box returns from array formula

  1. #1
    Registered User
    Join Date
    08-06-2008
    Location
    LONDON
    Posts
    10

    Combo Box returns from array formula

    Hi Everyone,

    The attached file has 3 sheets. Sheet 2 uses array formual to retunr values from sheet 3.
    On sheet one, I want to add a combo box (currently ive used data validation) but would prefer a combo box. Depending on what is selected fromt he combo boxes, I automatically want the result cells (pink) to return the values from the array. I have added notes and highlighted what the answers should be.

    I have palyed around with Index and match without much sucess!

    Anmy help is greatly appreciated.

    Regards
    Attached Files Attached Files

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    another array is needed
    i've put them under your values
    Attached Files Attached Files

+ 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. assistance with array formula
    By neowok in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2008, 05:00 PM
  2. Easiest one-cell formula for multiplying array elements
    By kayard in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2008, 03:55 AM
  3. Replacing "0" values with null string in array while preserving cell formula
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2007, 01:07 PM
  4. Array formula returns 0
    By erict in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-24-2007, 02:23 PM
  5. Inserting Array Formula
    By Jaymond Flurrie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-12-2007, 11:08 AM

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