=if(a2<>"",VLOOKUP(A2,'Sheet2'!$A$2:$J$613,6,FALSE),"")
This is a discussion on If not equal to null (or blank) formula within the Excel Questions forums, part of the Question Forums category; I am trying to write an formula that tests for a null value before executing the remainder of the formula. ...
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.
=if(a2<>"",VLOOKUP(A2,'Sheet2'!$A$2:$J$613,6,FALSE),"")
Computers can only do as much as what the programmer knows. The better the programmer, the better the end product will be.
=IF(COUNTIF('Sheet2'!$A$2:$A613,A2),VLOOKUP(A2,'Sheet2'!$A$2:$J$613,6,FALSE),"")
Neil
If(A2="","",formula)
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!
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?
Last edited by bigtonetucker; Nov 17th, 2014 at 08:50 PM.
Like this thread? Share it with others