IF and VLOOKUP HELP

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

[etaf]

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

do you need to format the cell to general ?

[BB1972]

DUPLICATE POST. Duplicate here

caramelf, welcome to the forum. Please refrain from duplicating posts - it's against the forum rules, and can lead to members trying to solve your question when it may already have been solved in the other post.

[caramelf23]

Thanks for the reply.

Formating to General will not work since the results is a date.