| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF iserror does not work
Hello I'm reposting a question a little different. Here we go this is my
simple formula =VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) and this works now I want to add if is error equal 0 =if(Iserror(VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)),0,VLOOKUP(A1,Sheet1!$ A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) it does not work.... thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF iserror does not work
I'm having a hard time seeing how your formula works.
IF(Sheet1!B1="Fax",4,FALSE -- Don Guillett Microsoft MVP Excel SalesAid Software "Wanna Learn" wrote in message ... Hello I'm reposting a question a little different. Here we go this is my simple formula =VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) and this works now I want to add if is error equal 0 =if(Iserror(VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)),0,VLOOKUP(A1,Sheet1!$ A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) it does not work.... thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF iserror does not work
THanks Don
if A3 (name) and B3 = Fax then results is number on column 4 ( if the name in A3 matches and the word fax macth in B3 then result in column D) ( if is error then 0 ) Thanks Again "Don Guillett" wrote: I'm having a hard time seeing how your formula works. IF(Sheet1!B1="Fax",4,FALSE -- Don Guillett Microsoft MVP Excel SalesAid Software "Wanna Learn" wrote in message ... Hello I'm reposting a question a little different. Here we go this is my simple formula =VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) and this works now I want to add if is error equal 0 =if(Iserror(VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)),0,VLOOKUP(A1,Sheet1!$ A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) it does not work.... thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF iserror does not work
Not sure if I'm just being stupid here. but arent column 4 and D the same
column? are you trying to get it to return the figure in column 4 or zero, so if the Name and Fax matches then put whats in column 4, otherwise put zero? "Wanna Learn" wrote: THanks Don if A3 (name) and B3 = Fax then results is number on column 4 ( if the name in A3 matches and the word fax macth in B3 then result in column D) ( if is error then 0 ) Thanks Again "Don Guillett" wrote: I'm having a hard time seeing how your formula works. IF(Sheet1!B1="Fax",4,FALSE -- Don Guillett Microsoft MVP Excel SalesAid Software "Wanna Learn" wrote in message ... Hello I'm reposting a question a little different. Here we go this is my simple formula =VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) and this works now I want to add if is error equal 0 =if(Iserror(VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)),0,VLOOKUP(A1,Sheet1!$ A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) it does not work.... thanks in advance |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF iserror does not work
Hello and Thanks Again
Yes! exactly , "if the Name and Fax matches then put whats in column 4, otherwise put zero?" sorry for the inconvenience "Tom Hewitt" wrote: Not sure if I'm just being stupid here. but arent column 4 and D the same column? are you trying to get it to return the figure in column 4 or zero, so if the Name and Fax matches then put whats in column 4, otherwise put zero? "Wanna Learn" wrote: THanks Don if A3 (name) and B3 = Fax then results is number on column 4 ( if the name in A3 matches and the word fax macth in B3 then result in column D) ( if is error then 0 ) Thanks Again "Don Guillett" wrote: I'm having a hard time seeing how your formula works. IF(Sheet1!B1="Fax",4,FALSE -- Don Guillett Microsoft MVP Excel SalesAid Software "Wanna Learn" wrote in message ... Hello I'm reposting a question a little different. Here we go this is my simple formula =VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) and this works now I want to add if is error equal 0 =if(Iserror(VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)),0,VLOOKUP(A1,Sheet1!$ A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) it does not work.... thanks in advance |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF iserror does not work
one more question what column/cell is your formula to go in?
"Wanna Learn" wrote: Hello and Thanks Again Yes! exactly , "if the Name and Fax matches then put whats in column 4, otherwise put zero?" sorry for the inconvenience "Tom Hewitt" wrote: Not sure if I'm just being stupid here. but arent column 4 and D the same column? are you trying to get it to return the figure in column 4 or zero, so if the Name and Fax matches then put whats in column 4, otherwise put zero? "Wanna Learn" wrote: THanks Don if A3 (name) and B3 = Fax then results is number on column 4 ( if the name in A3 matches and the word fax macth in B3 then result in column D) ( if is error then 0 ) Thanks Again "Don Guillett" wrote: I'm having a hard time seeing how your formula works. IF(Sheet1!B1="Fax",4,FALSE -- Don Guillett Microsoft MVP Excel SalesAid Software "Wanna Learn" wrote in message ... Hello I'm reposting a question a little different. Here we go this is my simple formula =VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) and this works now I want to add if is error equal 0 =if(Iserror(VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)),0,VLOOKUP(A1,Sheet1!$ A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) it does not work.... thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Iserror does not work for missing sheets in linked file | Links and Linking in Excel | |||
| use of ISERROR | Excel Worksheet Functions | |||
| Iserror | Excel Discussion (Misc queries) | |||
| Iserror & VBA | Excel Discussion (Misc queries) | |||
| ISERROR Functin to Much Work! | Excel Worksheet Functions | |||
Hybrid Mode
