Solved

ISNA Match formula

Posted on 2013-11-20
2
329 Views
Last Modified: 2013-11-20
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
Comment
Question by:Seamus2626
2 Comments
 
LVL 23

Accepted Solution

by:
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

by:Seamus2626
ID: 39663098
Perfect :-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Find word and 6 digit number 22 98
Delete all words in cell more than 5 words 7 48
Filling Blank Cells 14 21
Formula for time spans 10 23
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now