View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf MyVeryOwnSelf is offline
external usenet poster
 
Posts: 213
Default =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.