<div>
<div class="content wysiwyg-content">
Hi, a ss i am working on has the following formula 
 
=IF(ISNA(MATCH(&quot;High&quot;,(BV12:CB12,$BP12),0)),IF(ISNA(MATCH(&quot;Medium&quot;,(BV12:CB12,$BP12),0)),IF(ISNA(MATCH(&quot;Low&quot;,(BV12:CB12,$BP12),0)),0,&quot;Low&quot;),&quot;Medium&quot;),&quot;High&quot;) 
 
 
I am wondering is it possible to use a match like this 
 
(BV12:CB12,$BP12),0)) 
 
So thats a range, and then a seperate cell 
 
I think its returning an incorrect calculation 
 
Many thanks 
 
Seamus
</div>
</div>

Hi, a ss i am working on has the following formula

=IF(ISNA(MATCH("High",(BV12:CB12,$BP12),0)),IF(ISNA(MATCH("Medium",(BV12:CB12,$BP12),0)),IF(ISNA(MATCH("Low",(BV12:CB12,$BP12),0)),0,"Low"),"Medium"),"High")


I am wondering is it possible to use a match like this

(BV12:CB12,$BP12),0))

So thats a range, and then a seperate cell

I think its returning an incorrect calculation

Many thanks

Seamus

ISNA Match formula

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