Solved

Search for a value in an array with multiple rows and columns

Posted on 2012-03-19
1
188 Views
Last Modified: 2012-06-21
This is in follow up to my other post.

I need to search for a value in an array that has multiple rows and columns and return the value in the corresponding column/row.

In this screenshot,

Search for Course 2 and Hole 4 should return 1.
Search for Course 3 and Hole 12 should return 2.

The given parameters will be Course Name and Hole #.  

capture
0
Comment
Question by:mcnuttlaw
1 Comment
 
LVL 18

Accepted Solution

by:
krishnakrkc earned 500 total points
ID: 37737809
Hi

=index(c5:t8,match("course name",b5:b8,0),match(hole #,c4:t4))

Kris
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

770 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