Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Match Problem (Excel 2000/2003)

    Hi

    I am trying to add another parameter to the formula below, I would like to add IF(ISNA(MATCH("Needs Approval",'Lead Range'!Q7:Q97,0, aswell as "Too Low"

    What I am trying to achieve is if "Too Low" is matched then "At Least on Lead Price is Too Low" but if "Needs Approval" is matched, then "Needs Approval"

    else "Lead Prices OK




    =IF(ISNA(MATCH("Too Low",'Lead Range'!Q7:Q97,0)),"Lead Prices OK","At least one Lead Price is Too Low")


    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Match Problem (Excel 2000/2003)

    Does this do what you want?

    =IF(ISNA(MATCH("Too Low",'Lead Range'!Q7:Q97,0)),IF(ISNA(MATCH("Needs Approval",'Lead Range'!Q7:Q97,0)),"Lead Prices OK","Needs Approval"),"At least one Lead Price is Too Low")

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Match Problem (Excel 2000/2003)

    Hi Hans

    That works fine.

    Thank you very much.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •