Thread
:
=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0,1) what's D!
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf
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
MyVeryOwnSelf
View Public Profile
Find all posts by MyVeryOwnSelf
=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D!