<div>
Hi,<br />
<br />
pls refer to<br />
<br />
<a href="http://support.microsoft.com/kb/59482/en-us" rel="ugc">http://support.microsoft.com/kb/59482/en-us</a><br />
<br />
Regards
</div>


Hi,

pls refer to

http://support.microsoft.com/kb/59482/en-us [http://support.microsoft.com/kb/59482/en-us]

Regards

<div>
Hi,<br />
Thanks for that. It worked perfectly.<br />
Much appreciated<br />
Toco
</div>


Hi,
Thanks for that. It worked perfectly.
Much appreciated
Toco

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
Is it possible to perform a MATCH using more than one lookup value/range ?<br />
<br />
For example: <br />
<br />
=MATCH(A1,F:F,0) will return the row number if a match is found in column F of the value in A1<br />
<br />
What if I want to find the row number when more than one match/column condition exists ?<br />
<br />
For example:<br />
<br />
=MATCH(A1,F:F,0) and MATCH(B1,G:G,0) must both be TRUE before the row number is returned<br />
<br />
Thanks in anticipation<br />
Toco
</div>
</div>


Hi All,

Is it possible to perform a MATCH using more than one lookup value/range ?

For example: 

=MATCH(A1,F:F,0) will return the row number if a match is found in column F of the value in A1

What if I want to find the row number when more than one match/column condition exists ?

For example:

=MATCH(A1,F:F,0) and MATCH(B1,G:G,0) must both be TRUE before the row number is returned

Thanks in anticipation
Toco

In an Excel sheet can I MATCH a cell using more than one lookup value ?

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