View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu[_3_] muddan madhu[_3_] is offline
external usenet poster
 
Posts: 15
Default Column Compare Match

in Col E put this formula and drag it down

=if(isna(match(A1,c$1:c$100,0)),"","female")


"Christy" wrote:

Column A = Account Number
Column B = Patient Name
Column C = Account Number
Column D = Patient Name

I need to know which account numbers in Column A are listed in Column C. If
they are listed, I need the word female to display. I have tried the
following. IF(ISNUMBER(C1,A1:A17305)),"FEMALE",""). The problem is that the
range keeps changing as I copy and past the function. I need to search the
same range for each account. Please help.

Thanks.