Solved

# ISNA Match formula

Posted on 2013-11-20
331 Views
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
0
Question by:Seamus2626

LVL 23

Accepted Solution

NBVC earned 500 total points
ID: 39663071
Not really, but you can separate it like this, using AND to combine the 2 checks:

=IF(AND(\$BP12<>"High",ISNA(MATCH("High",(BV12:CB12),0))),IF(AND(\$BP12<>"Medium",ISNA(MATCH("Medium",(BV12:CB12),0))),IF(AND(\$BP12<>"Low",ISNA(MATCH("Low",(BV12:CB12),0))),0,"Low"),"Medium"),"High")
0

Author Closing Comment

ID: 39663098
Perfect :-)
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question