Posted to microsoft.public.excel.worksheet.functions

Jennifer

external usenet poster

Posts: 385

Vertical Lookup Question

Good day, I have a quick question. When using a vertical lookup that looks
at a named table for the returned values, if the item is not present in the
table it returns an N/A. Is there any way to have it return a zero (0) if it
is not present in the table?

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
Vertical Lookup from a List	B Golden	Excel Worksheet Functions	5	July 20th 06 02:45 PM
Relative Value to a Vertical Lookup Result?	jillteresa	Excel Worksheet Functions	3	May 19th 06 03:38 PM
Vertical Lookup problem	William	Excel Worksheet Functions	3	November 22nd 05 11:48 AM
Is it possible to do a vertical lookup that matches on 2 criteria	lshaw	Excel Worksheet Functions	4	May 16th 05 07:00 PM
Vertical lookup help needed	Have three columns R,S,T	Excel Worksheet Functions	1	December 11th 04 11:11 AM

All times are GMT +1. The time now is 11:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us