If not equal to null (or blank) formula

[jzeunik]

I am trying to write an formula that tests for a null value before executing the remainder of the formula. Here is the existing formula in cell M2:

=VLOOKUP(A2,'Sheet2'!$A$2:$J$613,6,FALSE)

What I'd like is to insert an IF test for A2: If A2 is not null/blank, then perform the VLOOKUP. If A2 is null/blank, leave cell M2 blank.

 

[DauntingGecko]

=if(a2<>"",VLOOKUP(A2,'Sheet2'!$A$2:$J$613,6,FALSE),"")

 

[njimack]

=IF(COUNTIF('Sheet2'!$A$2:$A613,A2),VLOOKUP(A2,'Sheet2'!$A$2:$J$613,6,FALSE),"")

 

[number kruncher]

If(A2="","",formula)

 

[jzeunik]

Thanks, Daunting. That worked. I thought I had tried the exact same formula, but I was getting errors. Obviously, something was wrong with my syntax.

Thanks everyone else for your replies, too!

 

[bigtonetucker]

I have a question on formatting a cell based on another cell. In Excel 1007, how do I get G3 to highlight itself red if F3 contains the word Fail and G3 is left blank, and then have G3 go back to white highlight if I put a value in G3?