Menu

How to make LOOKUP give zero if it can't find the lookup_value?

Search this Thread

Previous Post

Next Post

#1

Report Post

Dmitry Kopnichev

Posts: n/a

Default

How to make LOOKUP give zero if it can't find the lookup_value?

Hello
How to make LOOKUP give zero if it can't find the lookup_value?

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find last occurance of text in range	farutherford	Excel Worksheet Functions	5	August 30th 05 02:00 AM
Complicated lookup function	chrisrowe_cr	Excel Worksheet Functions	4	July 19th 05 05:52 PM
compicated lookup funtion	chrisrowe_cr	Excel Discussion (Misc queries)	4	July 19th 05 11:49 AM
The match and lookup functions can find literal data but not the same data referenced from a cell	Jeff Melvaine	Excel Discussion (Misc queries)	3	April 30th 05 01:29 PM
Using the Find tool in EXCEL	TK	Excel Worksheet Functions	2	February 11th 05 07:51 PM

All times are GMT +1. The time now is 07:30 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement