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

A

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
 
A

akphidelt

Enter this on the first row then copy down

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

T. Valko

One way:

Entered in E1 and copied down as needed:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top