• Status: Solved
• Priority: Medium
• Security: Public
• Views: 345

# ISNA Match formula

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
Seamus2626
1 Solution

Commented:
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 Commented:
Perfect :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.