Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am having a problem placing in an iserror with the following formula. I
have used iserror before to do if functions if(iserror(vlookup)),0,vlookup)) etc... but cannot get it to work with this many functions. I would like the formula to return a zero if the lookup is not present. I have tried to place the iserror directly after the if( and complete the rest of the formula with ,0,or(repeat formula). I'm pulling out my hair, which is bad, because I'm already half bald. =IF(OR(LEFT($G39,1)="2",LEFT($G39,1)="3"),VLOOKUP( LEFT($G39,6),'MONTH-YTD Balance Sheet'!$B$8:$P$1000,'MONTH-YTD Balance Sheet'!$B$4,FALSE)-VLOOKUP(LEFT($G39,6),'MONTH-YTD Balance Sheet'!$B$8:$P$1000,'MONTH-YTD Balance Sheet'!$B$3,FALSE),VLOOKUP(LEFT($G39,6),'MONTH-YTD Balance Sheet'!$B$8:$P$1000,'MONTH-YTD Balance Sheet'!$B$3,FALSE)-VLOOKUP(LEFT($G39,6),'MONTH-YTD Balance Sheet'!$B$8:$P$1000,'MONTH-YTD Balance Sheet'!$B$4,FALSE)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
ISERROR | Excel Worksheet Functions | |||
IF ISERROR | Excel Discussion (Misc queries) | |||
ISERROR | Excel Worksheet Functions | |||
iserror | Excel Worksheet Functions |