Excel Formula To Remove 0 from results. HELP PLEASE

[caramelf23]

Hi Everyone,

I would like help creating a formula to do the following:

Look if column b says the word Master, if it does then lookup column A in another sheet and return the value. If not, then lookup column J in the same sheet and return the value if the value is blank return a statement.

Here is the formulas I have so far:

IFERROR(IF(B2="Master",VLOOKUP(A2,'Sev1 Pilot Report_Master SRs'!A:F,5,FALSE),VLOOKUP(J2,'Sev1 Pilot Report_Master SRs'!A:F,5,FALSE)),"-").

My results column has dates. The problem I'm facing is my results come back with 1/0/1900. How can I correct this problem.

I have another formula IF(ISNUMBER(VLOOKUP(J3,'Sev1 Pilot Report_Master SRs'!A:E,5,FALSE)),VLOOKUP(J3,'Sev1 Pilot Report_Master SRs'!A:E,5,FALSE),"-") which also works but I can't successfully figure out how to write the formula to first look for B2=Master and look in both columns to give the dates.

HELP PLEASE>>>>>

[jeffreybrown]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.