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