[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2012-03-19
1
Medium Priority
?
204 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 18

Accepted Solution

by:
krishnakrkc earned 2000 total points
ID: 37737809
Hi

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

Kris
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

656 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