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,

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,

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,

The name before "!" indicates another worksheet or workbook.
--
tia


"FER" wrote:

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,

=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.

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