Nested if statement with vlookup + conditions

[jlugo]

HELLO Excel Experts!

Goal = Return a value "0" if cell value is blank or "1" if value matches same one on other sheet.

I feel I'm close but can't figure this out. I think I need if statement to set conditions of "1" TRUE or "0" FALSE & vlookup to match values on two different worksheets. I want a value of "1" instead of the value match specified by column number.

Any suggestions on a tentative formula?

Thanks

 

[JackDanIce]

Can you give the ranges and sheet names you're working with? Otherwise, modify following to suit your needs:

=IF(OR(ISERROR(MATCH(A1,Sheet2!A1:A10,0)),ISBLANK(A1)),0,1)

 

[jlugo]

Thank you Jack for your input! Here's what I have and the "0" works. I only need to figure out how to return "1" instead of the actual vlookup match.

=IF(ISERROR(VLOOKUP(Z3:Z308,'[SF BCN 09.04.12.xlsx]00O80000004PWWQ'!$A$2:$C$89128,3,FALSE)),"0",VLOOKUP(Z3:Z308,'[SF BCN 09.04.12.xlsx]00O80000004PWWQ'!$A$2:$C$89128,3,FALSE))</SPAN>

 

[jlugo]

I tried your formula and it works but........... is there a way to get this result without having to set up both unique identifier columns in ascending or descending order?