Posted to microsoft.public.excel.misc

lightbulb

external usenet poster

Posts: 61

VLOOKUP Condition

I'm trying to do a Vlookup where if it can't find the information in the
specified array, it returns a predetermined value...is there a way to do this?

Thanks!

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
two condition for vlookup?	shital shah	Excel Worksheet Functions	4	August 2nd 06 10:11 PM
2 condition vlookup	AZExcelNewbie	Excel Discussion (Misc queries)	1	February 17th 06 10:02 PM
VLOOKUP used only when IF condition is met	Bradley	Excel Worksheet Functions	3	November 22nd 05 05:32 PM
Multi-condition vlookup	Hobbeson	Excel Worksheet Functions	4	July 19th 05 02:57 AM
vlookup in two condition	val via OfficeKB.com	Excel Discussion (Misc queries)	1	March 18th 05 08:12 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us