Assigning True and False values in IF statements

[Blake_Begley]

So I am keeping up with 15000 items in an excel sheet and I am trying to make a summary sheet to keep up with some of the key things that I need to know.  I am trying to make an IF statement where I am checking the 15000 numbers I have in for a specific number, say these numbers are in column E. I want my function to output what I have entered into a cell in the same row that has the number in it but that is in a different column. Here is an example because I am not the best at explaining.

I want for the formula to look for Weld# 328 in column E and when it finds it I want it to spit out what is in column p for that same row that it finds Weld# 328 in, so the IF statement in this example would output:  W-6946, but if there were nothing in that cell then it would output a short string (know how to do this) something like "tracer not done yet"

[#2]

Hello @Blake_Begley,

That could be:

=IF(E2=328,P2,"tracer not done yet")

Copy down as necessary. 

[#3]

I would like it to check the whole E row not just E2, the problem I am having is making it output what is in the matching P row where it finds the number I am looking for.  thanks for the response!@PReagan 

[#4]

@Blake_Begley 

I'm not sure I understand what you mean by "I would like it to check the whole E row not just E2."

If you copy the formula down to cell E3, E4, and E5 then it becomes:

=IF(E3=328,P3,"tracer not done yet") 

=IF(E4=328,P4,"tracer not done yet")  

=IF(E5=328,P5,"tracer not done yet")

and so on... Is this not what you're looking for?

[#5]

Okay so here is my formula =IF(COUNTIFS('[00-G-3 WELD TRACKER 2-25-20.xlsx]Master Weld Tracker'!$E:$E,A3,'[00-G-3 WELD TRACKER 2-25-20.xlsx]Master Weld Tracker'!$P:$P,"*w*") = 1, "done", "not done") what this does is check the whole E column on another sheet and tells me if wherever there is a cell in my sheet that matches A3, if its corresponding P column has a W in it (which would make that countif statement = 1), it writes done if it doesnt it right not done. If the correspondind number matches whatever I have in A3 and there is a W in that rows P column, I would like it to output whatever is in that P column instead of done.  Would be a lot easier if I could show you @PReagan 

[#6]

@Blake_Begley 

Yes, a sample file would help tremendously. Would it be possible for you to upload a sample file of what you're trying to accomplish? (remove any sensitive information - of course) I think I understand but would like to work with a sample file to be sure.