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>>>>>