Improve Your Excel Lookup Formulas! (via Resident Conehead)

If you’re ready for nested formulas, take a look at this article. It can help with those pesky “#NA” returns from our VLOOKUP formulas.

If Excel can't find a value in a lookup formula, it will return #N/A. Do you want to return some more meaningful? Here's one way to do it by adding an IF clause to your formula. This tip works with all versions of Microsoft Excel. A standard lookup formula would look something like this: =VLOOKUP(5,A1:B10,2,FALSE). If Excel does not find the value of 5 in the lookup range, it will return the #N/A error which you can then use to your advantage. Th … Read More

via Resident Conehead

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s