• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

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

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
mcnuttlaw
Asked:
mcnuttlaw
1 Solution
 
krishnakrkcCommented:
Hi

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

Kris
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now