If, Or function or macro to compare 3 columns of numbers
 

Good morning;

I am not sure if I should post here or Excel programming. I need a function
or macro that will compare A1..A..., B1..B..., C1...C... , to D1...D...,
This would be across rows. If any of the values matched, I.E. A1, B1, C1,
matched D1, then enter the value in in E1, Else enter "No Match" in E1. This
would need to compare the columns row by row for approximately 3,000 rows of
data.

Is it possible to use an If Or function for more than two comparisons
without going to a macro.
Thanks in advance
Phil

If, Or function or macro to compare 3 columns of numbers
 

Enter this on the first row then copy down

=IF(OR(A1=D1,B1=D1,C1=D1),D1,"No Match")

"AuthorizedUserPF" wrote:

Good morning;

I am not sure if I should post here or Excel programming. I need a function
or macro that will compare A1..A..., B1..B..., C1...C... , to D1...D...,
This would be across rows. If any of the values matched, I.E. A1, B1, C1,
matched D1, then enter the value in in E1, Else enter "No Match" in E1. This
would need to compare the columns row by row for approximately 3,000 rows of
data.

Is it possible to use an If Or function for more than two comparisons
without going to a macro.
Thanks in advance
Phil

If, Or function or macro to compare 3 columns of numbers
 

One way:

Entered in E1 and copied down as needed:

=IF(COUNTIF(A1:C1,D1),D1,"no match")

--
Biff
Microsoft Excel MVP


"AuthorizedUserPF" wrote in
message ...
Good morning;

I am not sure if I should post here or Excel programming. I need a
function
or macro that will compare A1..A..., B1..B..., C1...C... , to D1...D...,
This would be across rows. If any of the values matched, I.E. A1, B1, C1,
matched D1, then enter the value in in E1, Else enter "No Match" in E1.
This
would need to compare the columns row by row for approximately 3,000 rows
of
data.

Is it possible to use an If Or function for more than two comparisons
without going to a macro.
Thanks in advance
Phil

If, Or function or macro to compare 3 columns of numbers
 

Thanks

akphidelt

That will work.

"AuthorizedUserPF" wrote:

Good morning;

I am not sure if I should post here or Excel programming. I need a function
or macro that will compare A1..A..., B1..B..., C1...C... , to D1...D...,
This would be across rows. If any of the values matched, I.E. A1, B1, C1,
matched D1, then enter the value in in E1, Else enter "No Match" in E1. This
would need to compare the columns row by row for approximately 3,000 rows of
data.

Is it possible to use an If Or function for more than two comparisons
without going to a macro.
Thanks in advance
Phil