+ Reply to Thread
Results 1 to 4 of 4

Returning value based on two criteria

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    51

    Question Returning value based on two criteria

    Hi all,

    Could someone please tell me how to return a value based on two criteria's?

    Sheet2 contains my database, basically I want my formula to search for the correct date & return the value that corresponds the that mode of transport

    ThanksExcel example.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Returning value based on two criteria

    Hi,

    Look at the formulas on Sheet1.

    I hope this helps. Please mark this thread as solved and click on the * next to my post to say thanks if you are satisfied with the solution.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Returning value based on two criteria

    Thank you so much, that is a big help! thank you.

    Just one more question - your lookup array is Sheet2!$B$3:$F$3 which is fine for the example question. However, my actual spreadsheet has 100's of columns/rows, and I plan to update my database daily. Therefore, is there a way I can set my array to be unlimited? (if that makes sense)

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Returning value based on two criteria

    There sure is. Replace the lookup array with:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Returning value based on search criteria
    By kolonel in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-17-2013, 09:16 PM
  2. [SOLVED] Returning all values based on criteria
    By SimonXL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-13-2012, 01:19 PM
  3. Returning a value based on certain criteria
    By stait in forum Excel General
    Replies: 5
    Last Post: 12-21-2011, 02:03 PM
  4. Replies: 2
    Last Post: 04-03-2011, 06:37 PM
  5. Returning Results Based on Two Criteria
    By [email protected] in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-23-2005, 10:05 AM

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