<div>
<div class="content wysiwyg-content">
This is in follow up to my other <a href="https://www.experts-exchange.com/questions/27637416/Search-for-a-value-in-an-array-with-multiple-rows-and-columns.html" rel="ugc">post</a>.<br />
<br />
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.<br />
<br />
In this screenshot,<br />
<br />
Search for Course 2 and Hole 4 should return 1.<br />
Search for Course 3 and Hole 12 should return 2.<br />
<br />
The given parameters will be Course Name and Hole #. &nbsp;<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/03_w12/561207/capture.jpg" target="_blank" title="capture (31 KB)"><img alt="capture" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2012/03_w12/800_561207/capture.jpg" /></a>
</div>
</div>


capture.jpg

This is in follow up to my other post (https://www.experts-exchange.com/questions/27637416/Search-for-a-value-in-an-array-with-multiple-rows-and-columns.html).

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 #.  



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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.