View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default =IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0 ,1) what's D!

Oops. I missed that it was a sheet named "D". It is better to include your
formula in the body of the message and not just in the subject.

Regards.

--

"PCLIVE" wrote in message
...
Looks like a typo to me. Probably should be a one (1) and not shift+1
which would give you "!".

Regards,
Paul


--

"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,