View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default 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