Posted to microsoft.public.excel.worksheet.functions

Troy[_2_]

external usenet poster

Posts: 18

Vlookup return Zero if not there

I'm doing a vlookup. If the value I"m looking up is not in the arrary I've
set up I want the formual to return a zero.

Here's the formula: =VLOOKUP(C11,'Payment Matrix'!B128:C134,2,TRUE)

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
vlookup w/ more than one return value	amy	Excel Discussion (Misc queries)	9	January 16th 09 05:29 PM
VLookUp - Does the VLookUp return the exact information?	Cpviv	Excel Worksheet Functions	2	October 28th 08 09:57 AM
Vlookup #N/A return value	Ladysearcher	Excel Worksheet Functions	2	August 15th 07 12:24 AM
How do I return the row for a value I VLOOKUP?	fryerfarm	Excel Worksheet Functions	2	December 1st 05 09:40 PM
VLookup Return Value	Kevin	Excel Worksheet Functions	4	December 3rd 04 03:05 PM

All times are GMT +1. The time now is 05:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us