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

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

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

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

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

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

IF iserror does not work
 

Tom
formula is going in cell H1
"Tom Hewitt" wrote:

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

IF iserror does not work
 

Assuming the formula is going down all the rows of data.

Try

If(A1=B1,VLOOKUP(A1,A1:D200,4,false),0)

"Wanna Learn" wrote:

Tom
formula is going in cell H1
"Tom Hewitt" wrote:

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

IF iserror does not work
 

Tom Thank you Thank you

"Tom Hewitt" wrote:

Assuming the formula is going down all the rows of data.

Try

If(A1=B1,VLOOKUP(A1,A1:D200,4,false),0)

"Wanna Learn" wrote:

Tom
formula is going in cell H1
"Tom Hewitt" wrote:

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