Help with formula

[annep833]

Hello, I am looking for help with this formula. It's not working and I know I'm doing something wrong. I am trying to combine these two formulas:

=IF((ISNUMBER(SEARCH("",F17)),"Done in Q1"))

=IF(ISERROR(MATCH(C:C,'Q2 Quality'!$H$2:$H$7500,0)),"",INDEX('Q2 Quality'!$I$2:$I$7500,MATCH(C:C,'Q2 Quality'!$H$2:$H$7500,0)))

The ISERROR formula works for me to pull the data from the Q2 Quality worksheet into my ALL worksheet but I also want to add that if the

 

[Fluff]

You are not matching a value anywhere in col C, you are matching the value in col C on the same row as the formula.

 

[annep833]

I need to match a value in the column, not a specific cell. If it works, what is the harm?

Okay. Thanks again for your help. You won't have to deal with me anymore. Everyone on this site thinks I'm an idiot so I hate using it. I wish I had time to learn more about Excel so that I don't have to rely on others. I do try on my own but I end up wasting too much time trying to come up with a solution. Anyway, thanks again.

 

[Fluff]

I'm sorry you feel that way, but I certainly don't think you're an idiot, we all have to start somewhere.
Whilst you can use the whole column reference it is generally considered to be "bad practice" & if you ever switch to an Excel version with the dynamic functions it could cause problems.
I was just trying to "steer" you in the right direction. but at the end of the day it's your choice & if you prefer using whole column references, then stick with them.

 

[annep833]

I'm sorry you feel that way, but I certainly don't think you're an idiot, we all have to start somewhere.
Whilst you can use the whole column reference it is generally considered to be "bad practice" & if you ever switch to an Excel version with the dynamic functions it could cause problems.
I was just trying to "steer" you in the right direction. but at the end of the day it's your choice & if you prefer using whole column references, then stick with them.

I appreciate the advice!

 

[Fluff]