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

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!
 

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,

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

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!
 

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

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

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