Results 1 to 9 of 9

Find value based on three criterias

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2015
    Location
    Stockholm, Sweden
    MS-Off Ver
    Professional Plus 2010
    Posts
    28

    Find value based on three criterias

    I have tried to find the correct solution both here in the forum and on various sites, but I can´t wrap my head around how to solve this.
    Attached you find an easy example of what I´m trying to achieve, but in reality the file is of course much larger.

    • In column A I have the first criteria, in this example a fruit.
    • On row 1 is the second criteria, in this example Cost price
    • On row 2 is the third criteria, in this example month

    So how would a formula look that answers the question “What was the Cost price of Pears in March” based on the values in A8:A10?

    I have experimented both with an array INDEX/MATCH and a VLOOKUP with multiple MATCH, but can´t get it to work.

    Very thankful for all input, thank you!
    Attached Files Attached Files
    Last edited by AliGW; 07-09-2019 at 08:24 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find sum of difference in a single column based on criterias.
    By ankitpsaraogi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2019, 04:14 AM
  2. Find value based off 2 Criterias
    By spunner87 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2018, 12:36 PM
  3. [SOLVED] Find a value based on multiple criterias
    By Charli53 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2017, 05:09 AM
  4. [SOLVED] Macro Find set criterias to a colomn of number, delete the rows that don't meet criterias
    By TAMMY32 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-03-2017, 04:09 PM
  5. [SOLVED] Find the first and second corresponding value based on criterias
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2015, 12:26 PM
  6. find top 10 values based on multiple criterias
    By saurabhlotankar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2014, 01:47 AM
  7. Replies: 4
    Last Post: 09-08-2010, 10:57 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