Solved

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

Posted on 2012-03-19
1
183 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

744 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now