Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
fluffy
 
Posts: n/a
Default Seemingly impossible task

In the example below I am trying to determine the rows that contain duplicate
account numbers. I am thinking that if I could do an IF/AND function I could
get the information I want. The second column gives me the results I want, I
just can't get there. Basically if an account in column one is also located
in column 3 and column 4 is a "91" I would like a return of no. If an
account in column 1 is in column 3 and column 4 is a "92" I would like a
return of yes. If an account in column 1 is not in column two, regardless of
what is in column 4, I would like a return of "single". Is this possible.
I have been completely unsuccessful

acct 1 acct 2 tied ind
123456 no 978564 91
546464 no 97974649 91
9849464 no 974649 91
46464 no 657987 91
657987 yes 46464 92
974649 yes 9849464 92
97974649 yes 546464 92
978564 yes 123456 92
1111111 single 2222222 92

  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

=IF(ISNA(VLOOKUP(A2,$C$2:$C$9,1,FALSE)),"single",I F(D2=91,"no","yes"))

Fill down as far as needed

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"fluffy" wrote in message
...
In the example below I am trying to determine the rows that contain
duplicate
account numbers. I am thinking that if I could do an IF/AND function I
could
get the information I want. The second column gives me the results I
want, I
just can't get there. Basically if an account in column one is also
located
in column 3 and column 4 is a "91" I would like a return of no. If an
account in column 1 is in column 3 and column 4 is a "92" I would like a
return of yes. If an account in column 1 is not in column two, regardless
of
what is in column 4, I would like a return of "single". Is this
possible.
I have been completely unsuccessful

acct 1 acct 2 tied ind
123456 no 978564 91
546464 no 97974649 91
9849464 no 974649 91
46464 no 657987 91
657987 yes 46464 92
974649 yes 9849464 92
97974649 yes 546464 92
978564 yes 123456 92
1111111 single 2222222 92



  #3   Report Post  
fluffy
 
Posts: n/a
Default

this works wonderfully. Thank you so much. You have saved what is left of
my hair.

"Niek Otten" wrote:

=IF(ISNA(VLOOKUP(A2,$C$2:$C$9,1,FALSE)),"single",I F(D2=91,"no","yes"))

Fill down as far as needed

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"fluffy" wrote in message
...
In the example below I am trying to determine the rows that contain
duplicate
account numbers. I am thinking that if I could do an IF/AND function I
could
get the information I want. The second column gives me the results I
want, I
just can't get there. Basically if an account in column one is also
located
in column 3 and column 4 is a "91" I would like a return of no. If an
account in column 1 is in column 3 and column 4 is a "92" I would like a
return of yes. If an account in column 1 is not in column two, regardless
of
what is in column 4, I would like a return of "single". Is this
possible.
I have been completely unsuccessful

acct 1 acct 2 tied ind
123456 no 978564 91
546464 no 97974649 91
9849464 no 974649 91
46464 no 657987 91
657987 yes 46464 92
974649 yes 9849464 92
97974649 yes 546464 92
978564 yes 123456 92
1111111 single 2222222 92




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 05:08 PM
Remove template help task pane from startup DotC Excel Discussion (Misc queries) 0 August 28th 05 11:44 PM
Task Pane Mike Setting up and Configuration of Excel 3 May 26th 05 09:29 AM
loop trough e-mail address list to send task lists with outlook Paul. Excel Discussion (Misc queries) 2 April 14th 05 12:48 PM
Databases for tracking work and task completion SSgt Roberts Excel Worksheet Functions 1 December 6th 04 09:25 PM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"