Column Matching/Comparing

C

Christy

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.
 
D

Dave Peterson

Check your earlier post.
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.
Click to expand...
 

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

Similar Threads

Column Compare Match 3
Sum Column C for duplicate account number in Column A 8
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Chart from 1 Column 1
macro or formula to find an account number in another list of numb 1
Macro for comparing columns and highlighting matching/differences 14
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
SUM - IF - AND 7

Top