Posted to microsoft.public.excel.worksheet.functions

MyVeryOwnSelf MyVeryOwnSelf is offline

external usenet poster

Posts: 213

=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D!

=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D!

It's the name of the worksheet tab where $C$5:$C$75 is found.

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
Syntax to Nest ISERROR with a VLookup	Christine	Excel Worksheet Functions	2	March 8th 07 08:36 PM
Syntax to Nest ISERROR with a VLookup	bj	Excel Worksheet Functions	0	March 8th 07 07:21 PM
Iserror and vlookup	T De Villiers	Excel Worksheet Functions	1	January 27th 06 04:00 PM
ISERROR VLOOKUP	Carole O	Excel Worksheet Functions	1	June 1st 05 02:08 AM
Iserror and Vlookup	ShineboxNJ	Excel Worksheet Functions	1	November 18th 04 11:31 PM

All times are GMT +1. The time now is 10:04 AM.

About Us

"It's about Microsoft Excel"