Solved

Index & Match Help

Posted on 2016-11-09
2
34 Views
Last Modified: 2016-11-09
I am trying to create an Index & Match formula with 3 match criteria's, one of which needs to be greater than or equal to a value in a column. And then I also need to match one of 4 columns along with the 3 match criteria's. In the attached sample file I have illustrated what I am looking for and what the criteria's are.
Sample.xlsx
0
Comment
Question by:Lawrence Salvucci
2 Comments
 
LVL 21

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 41881124
Check attached file.
Sample-match-3.xlsx
0
 
LVL 1

Author Closing Comment

by:Lawrence Salvucci
ID: 41881392
Thank you again for your help!!!
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question