Thread: =IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0,1) what's D!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default =IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D!
"D" is the sheet name.

The "!" character is the sheet name identifier. It lets Excel know that what
preceds it is a sheet name.

Sheet1!
Sales!
August 2007!
Summary!

--
Biff
Microsoft Excel MVP


"FER" wrote in message
...
Hello:

I would like to know what does the D! stand for? if the range of cells is
where VLOOK NEED TO LOOK UP what is the D!?

Thank you,



Reply With QuoteReply With Quote