<div>
Hi Seth,<br />
<br />
I was wondering if you tried this solution and if it was successful?
</div>


Hi Seth,

I was wondering if you tried this solution and if it was successful?

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
The formula I'm using is:<br />
<br />
=index(WR!A:G,match(A1&amp;A2,<wbr />WR!A:A&amp;WR!<wbr />F:F,0),2)<br />
<br />
This works fine so long as the values in A1 and A2 are fixed values. <br />
<br />
But what I'd like to do is replace A2 something that says &quot;anything greater than zero.&quot; Fiddling with the match_type just returns the wrong values.<br />
<br />
Thanks in advance.<br />
<br />
Seth
</div>
</div>


Hello,

The formula I'm using is:

=index(WR!A:G,match(A1&A2,WR!A:A&WR!F:F,0),2)

This works fine so long as the values in A1 and A2 are fixed values. 

But what I'd like to do is replace A2 something that says "anything greater than zero." Fiddling with the match_type just returns the wrong values.

Thanks in advance.

Seth

Index w/ Match variables

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