This is what I posted a day ago and was told to use IfError. I assume I out
it in the H column but I have it already doing =F3+G3 and in G3 I am using
=if(E35=B$6,
$AA$2,"")

I currently need help on a project m tryin got complete. I have 2 codes
that gather data for me. one matches the column and other matches the row
and then gives em the data in the column. I have this going to a group of
cells we can call F3 thru F8. This part works fine. I have used =if(E35=B$6,
$AA$2,"") to match and place a 1 so that it can be added to my formula. If
it matches it works great. However, Where it searches G35 doesnt match in F3
say thru F7 but matches F8 I get N/A and then the numbers will not be
displayed. How do I get it to place a zero in the cell if it doesnt match to
the formula works. Her is example.
E F G H E35 = RFL B6 = RFL AA2
1
3 CHA 8 0 8
4 DEX 8 0 8
5 WIL 8 0 8
6 INT 8 0 8
7 RFL 8 1 9
8 DRV 8 0 8
9 ONI 8 0 8
10 PAR 8 0 8

Now when I copy it to different Cells to make it seach for and of E i get
this:

E F G H E35 = RFL B6 =
RFL AA2 1
3 CHA 8 N/A ###
4 DEX 8 N/A ###
5 WIL 8 N/A ###
6 INT 8 N/A ###
7 RFL 8 1 9
8 DRV 8 N/A ###
9 ONI 8 N/A ###
10 PAR 8 N/A ### B6 can only match one fo the items E3:E10.

I need it to take out the N/A and leave a zero or blank so that the formula
is completes as the column H3:H10 is copied somewhere else.

QUESTION is where and how do I put in IfError. Thanks

Forgot to add I know nothing of VB.

"Khanjohn" wrote:

This is what I posted a day ago and was told to use IfError. I assume I out
it in the H column but I have it already doing =F3+G3 and in G3 I am using
=if(E35=B$6,
$AA$2,"")

I currently need help on a project m tryin got complete. I have 2 codes
that gather data for me. one matches the column and other matches the row
and then gives em the data in the column. I have this going to a group of
cells we can call F3 thru F8. This part works fine. I have used =if(E35=B$6,
$AA$2,"") to match and place a 1 so that it can be added to my formula. If
it matches it works great. However, Where it searches G35 doesnt match in F3
say thru F7 but matches F8 I get N/A and then the numbers will not be
displayed. How do I get it to place a zero in the cell if it doesnt match to
the formula works. Her is example.
E F G H E35 = RFL B6 = RFL AA2
1
3 CHA 8 0 8
4 DEX 8 0 8
5 WIL 8 0 8
6 INT 8 0 8
7 RFL 8 1 9
8 DRV 8 0 8
9 ONI 8 0 8
10 PAR 8 0 8

Now when I copy it to different Cells to make it seach for and of E i get
this:

E F G H E35 = RFL B6 =
RFL AA2 1
3 CHA 8 N/A ###
4 DEX 8 N/A ###
5 WIL 8 N/A ###
6 INT 8 N/A ###
7 RFL 8 1 9
8 DRV 8 N/A ###
9 ONI 8 N/A ###
10 PAR 8 N/A ### B6 can only match one fo the items E3:E10.

I need it to take out the N/A and leave a zero or blank so that the formula
is completes as the column H3:H10 is copied somewhere else.

QUESTION is where and how do I put in IfError. Thanks

Basically, the format of the ifiserror formula should be
=If(iserror(FORMULA),0,(FORMULA)) ie. if the formula returns an error, show a
zero (or whatever - you might prefer "") otherwise, show me the formula.

For example, if you formula was =A1+A2, then you would apply iserror like
this:
=IF(ISERROR(A1+A2),0,A1+A2)

Hope that makes sense.

"Khanjohn" wrote:

This is what I posted a day ago and was told to use IfError. I assume I out
it in the H column but I have it already doing =F3+G3 and in G3 I am using
=if(E35=B$6,
$AA$2,"")

I currently need help on a project m tryin got complete. I have 2 codes
that gather data for me. one matches the column and other matches the row
and then gives em the data in the column. I have this going to a group of
cells we can call F3 thru F8. This part works fine. I have used =if(E35=B$6,
$AA$2,"") to match and place a 1 so that it can be added to my formula. If
it matches it works great. However, Where it searches G35 doesnt match in F3
say thru F7 but matches F8 I get N/A and then the numbers will not be
displayed. How do I get it to place a zero in the cell if it doesnt match to
the formula works. Her is example.
E F G H E35 = RFL B6 = RFL AA2
1
3 CHA 8 0 8
4 DEX 8 0 8
5 WIL 8 0 8
6 INT 8 0 8
7 RFL 8 1 9
8 DRV 8 0 8
9 ONI 8 0 8
10 PAR 8 0 8

Now when I copy it to different Cells to make it seach for and of E i get
this:

E F G H E35 = RFL B6 =
RFL AA2 1
3 CHA 8 N/A ###
4 DEX 8 N/A ###
5 WIL 8 N/A ###
6 INT 8 N/A ###
7 RFL 8 1 9
8 DRV 8 N/A ###
9 ONI 8 N/A ###
10 PAR 8 N/A ### B6 can only match one fo the items E3:E10.

I need it to take out the N/A and leave a zero or blank so that the formula
is completes as the column H3:H10 is copied somewhere else.

QUESTION is where and how do I put in IfError. Thanks

You have a response about =iferror() at your previous thread.

Khanjohn wrote:

This is what I posted a day ago and was told to use IfError. I assume I out
it in the H column but I have it already doing =F3+G3 and in G3 I am using
=if(E35=B$6,
$AA$2,"")

I currently need help on a project m tryin got complete. I have 2 codes
that gather data for me. one matches the column and other matches the row
and then gives em the data in the column. I have this going to a group of
cells we can call F3 thru F8. This part works fine. I have used =if(E35=B$6,
$AA$2,"") to match and place a 1 so that it can be added to my formula. If
it matches it works great. However, Where it searches G35 doesnt match in F3
say thru F7 but matches F8 I get N/A and then the numbers will not be
displayed. How do I get it to place a zero in the cell if it doesnt match to
the formula works. Her is example.
E F G H E35 = RFL B6 = RFL AA2
1
3 CHA 8 0 8
4 DEX 8 0 8
5 WIL 8 0 8
6 INT 8 0 8
7 RFL 8 1 9
8 DRV 8 0 8
9 ONI 8 0 8
10 PAR 8 0 8

Now when I copy it to different Cells to make it seach for and of E i get
this:

E F G H E35 = RFL B6 =
RFL AA2 1
3 CHA 8 N/A ###
4 DEX 8 N/A ###
5 WIL 8 N/A ###
6 INT 8 N/A ###
7 RFL 8 1 9
8 DRV 8 N/A ###
9 ONI 8 N/A ###
10 PAR 8 N/A ### B6 can only match one fo the items E3:E10.

I need it to take out the N/A and leave a zero or blank so that the formula
is completes as the column H3:H10 is copied somewhere else.

QUESTION is where and how do I put in IfError. Thanks

--

Dave Peterson

Thanks gusy Plum answer fixed the problem. thank you for explaining it so
well.
"Dave Peterson" wrote:

You have a response about =iferror() at your previous thread.

Khanjohn wrote:

This is what I posted a day ago and was told to use IfError. I assume I out
it in the H column but I have it already doing =F3+G3 and in G3 I am using
=if(E35=B$6,
$AA$2,"")

I currently need help on a project m tryin got complete. I have 2 codes
that gather data for me. one matches the column and other matches the row
and then gives em the data in the column. I have this going to a group of
cells we can call F3 thru F8. This part works fine. I have used =if(E35=B$6,
$AA$2,"") to match and place a 1 so that it can be added to my formula. If
it matches it works great. However, Where it searches G35 doesnt match in F3
say thru F7 but matches F8 I get N/A and then the numbers will not be
displayed. How do I get it to place a zero in the cell if it doesnt match to
the formula works. Her is example.
E F G H E35 = RFL B6 = RFL AA2
1
3 CHA 8 0 8
4 DEX 8 0 8
5 WIL 8 0 8
6 INT 8 0 8
7 RFL 8 1 9
8 DRV 8 0 8
9 ONI 8 0 8
10 PAR 8 0 8

Now when I copy it to different Cells to make it seach for and of E i get
this:

E F G H E35 = RFL B6 =
RFL AA2 1
3 CHA 8 N/A ###
4 DEX 8 N/A ###
5 WIL 8 N/A ###
6 INT 8 N/A ###
7 RFL 8 1 9
8 DRV 8 N/A ###
9 ONI 8 N/A ###
10 PAR 8 N/A ### B6 can only match one fo the items E3:E10.

I need it to take out the N/A and leave a zero or blank so that the formula
is completes as the column H3:H10 is copied somewhere else.

QUESTION is where and how do I put in IfError. Thanks

--

Dave Peterson