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

F

FER

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

PCLIVE

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

Regards,
Paul
 
T

T. Valko

"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!
 
P

PCLIVE

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.

--
 
Top