If not equal to null (or blank) formula

jzeunik

New Member
Joined
Mar 28, 2011
Messages
11
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.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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!
 
Upvote 0
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:
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,927
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top