| Home |
| Search |
| Today's Posts |
|
#3
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, |
| 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 | |||
Threaded Mode
