IF iserror does not work

[Wanna Learn]

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

 

[Don Guillett]

I'm having a hard time seeing how your formula works.--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Wanna Learn]

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

 

[Tom Hewitt]

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]

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]

one more question what column/cell is your formula to go in?

 

[Wanna Learn]

Tom
formula is going in cell H1

one more question what column/cell is your formula to go in?

 

[Tom Hewitt]

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

Try

If(A1=B1,VLOOKUP(A1,A1200,4,false),0)

 

[Wanna Learn]

Tom Thank you Thank you

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

Try

If(A1=B1,VLOOKUP(A1,A1200,4,false),0)