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

 

[arthurbr]

Your use of the MATCH function looks incorrect ( see syntax)
What are you trying to do?

 

[annep833]

I'm not sure why it cut me off. The ISERROR works for me to pull the data in column I from Q2 Quality if Column H in Q2 Quality matches Column C in my ALL Worksheet. I want to add to the formula to enter "Done in Q1" if Column F in the ALL worksheet has text. If it has no text, I just want it to return the result of the ISERROR formula (pulling the data from the Q2 Quality sheet).

 

[Fluff]

Maybe

=IF(F2<>"","Done in Q1",IFERROR(INDEX('Q2 Quality'!$I$2:$I$7500,MATCH(C2,'Q2 Quality'!$H$2:$H$7500,0)),""))

 

[annep833]

Your use of the MATCH function looks incorrect ( see syntax)
What are you trying to do?

I'm not sure why it cut me off. The ISERROR works for me to pull the data in column I from Q2 Quality if Column H in Q2 Quality matches Column C in my ALL Worksheet. I want to add to the formula to enter "Done in Q1" if Column F in the ALL worksheet has text. If it has no text, I just want it to return the result of the ISERROR formula (pulling the data from the Q2 Quality sheet).

 

[Fluff]

You've already said that. Have you tried the formula I suggested?

 

[annep833]

Maybe

=IF(F2<>"","Done in Q1",IFERROR(INDEX('Q2 Quality'!$I$2:$I$7500,MATCH(C2,'Q2 Quality'!$H$2:$H$7500,0)),""))

You've already said that. Have you tried the formula I suggested?

Sorry for sending it twice... I tried that and it isn't pulling the data from the Q2 Quality Sheet but it is inputting the Done in Q1 text so halfway there. I still need it to return the text from the Q2 Quality sheet if there isn't text in my ALL sheet in column F. Thanks!

 

[annep833]

I got it to work by changing C2 to C:C. Thank you so much for your help!

 

[Fluff]

You really shouldn't use entire columns like that, you should refer to the actual cell your interested in.

 

[annep833]

You really shouldn't use entire columns like that, you should refer to the actual cell your interested in.

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