Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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, |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax to Nest ISERROR with a VLookup | Excel Worksheet Functions | |||
Syntax to Nest ISERROR with a VLookup | Excel Worksheet Functions | |||
Iserror and vlookup | Excel Worksheet Functions | |||
ISERROR VLOOKUP | Excel Worksheet Functions | |||
Iserror and Vlookup | Excel Worksheet Functions |