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

[AuthorizedUserPF]

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

 

[akphidelt]

Enter this on the first row then copy down

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

 

[T. Valko]

One way:

Entered in E1 and copied down as needed:

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

 

[AuthorizedUserPF]

Thanks

akphidelt

That will work.