COMPARING/MATCHING COLUMNS

[Christy]

I have 4 columns.
Column A = Account Number
Colunm B = Patient Name
Column C = Account Number
Colunm D = Patient Name

I need to know which account numbers in column A are listed in column and if
so I need the cell to state female. I have tried
If(ISNUMBER(MATCH(C1,A1:A17305),"FEMALE",""). This works in the first cell
the range keeps changing as I copy and past the formula. I need it to search
the same range.

Thanks.

 

[Tom [Pepper] Willett]

This is not an Excel newsgroup, but FrontPage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
:I have 4 columns.
: Column A = Account Number
: Colunm B = Patient Name
: Column C = Account Number
: Colunm D = Patient Name
:
: I need to know which account numbers in column A are listed in column and
if
: so I need the cell to state female. I have tried
: If(ISNUMBER(MATCH(C1,A1:A17305),"FEMALE",""). This works in the first
cell
: the range keeps changing as I copy and past the formula. I need it to
search
: the same range.
:
: Thanks.

 

[Stefan B Rusynko]

See Excel help on Relative and Absolute cell addresses
It should be:
If(ISNUMBER(MATCH(C1,$A$1:$A$17305),"FEMALE","")
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I have 4 columns.
| Column A = Account Number
| Colunm B = Patient Name
| Column C = Account Number
| Colunm D = Patient Name
|
| I need to know which account numbers in column A are listed in column and if
| so I need the cell to state female. I have tried
| If(ISNUMBER(MATCH(C1,A1:A17305),"FEMALE",""). This works in the first cell
| the range keeps changing as I copy and past the formula. I need it to search
| the same range.
|
| Thanks.