Posted to microsoft.public.excel.misc

[email protected] ciojr@yahoo.com is offline

external usenet poster

Posts: 2

nested vlookup needs to remove #name?

I have the following
=IF(VLOOKUP(I14,'ISSUES (2)'!$B:$M,12,FALSE)="M",
20,IF(VLOOKUP(I14,'ISSUES (2)'!$B:$M,12,FALSE)="H",
40,ifIF(VLOOKUP(I14,'ISSUES (2)'!$B:$M,12,FALSE)="L",12,0)))

if no match is found, i get #NAME?

how can i replace this with 0 if no match is found

Thanks in advance and happy easter.

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
Nested IF with a VLOOKUP?	plunk25	Excel Worksheet Functions	5	July 25th 06 06:07 PM
Can Someone Help me With a Nested VLOOKUP	[email protected]	Excel Discussion (Misc queries)	1	December 17th 05 02:24 PM
Nested vlookup	tojo107	Excel Discussion (Misc queries)	1	August 10th 05 11:06 PM
nested ifs or vlookup or ?	tannersnonni	Excel Discussion (Misc queries)	1	June 1st 05 02:39 AM
Nested vlookup?	astronautika	Excel Worksheet Functions	1	November 19th 04 06:12 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us