Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 22nd 05, 05:14 AM
mdeanda
 
Posts: n/a
Default Match two lists and return a value

I have a worksheet with 12000 lines of employee data. At the end of the work
sheet I appended 200 names in the name column. I need a formula that will
match the 200 names with the previous 12000 lines an returen a 1 in the
corresponding/matching row in the A column

  #2   Report Post  
Old May 22nd 05, 05:59 AM
mdeanda
 
Posts: n/a
Default



"mdeanda" wrote:

I have a worksheet with 12000 lines of employee data. At the end of the work
sheet I appended 200 names in the name column. I need a formula that will
match the 200 names with the previous 12000 lines an returen a 1 in the
corresponding/matching row in the A column


Why won't the following IF statement work?
IF(B2=(B12347:B12565),1," ")





  #3   Report Post  
Old May 22nd 05, 07:26 AM
Biff
 
Posts: n/a
Default

Hi!

Try this:

=IF(COUNTIF(B$12347:B$12565,B2),1,"")

Biff

"mdeanda" wrote in message
...


"mdeanda" wrote:

I have a worksheet with 12000 lines of employee data. At the end of the
work
sheet I appended 200 names in the name column. I need a formula that
will
match the 200 names with the previous 12000 lines an returen a 1 in the
corresponding/matching row in the A column


Why won't the following IF statement work?
IF(B2=(B12347:B12565),1," ")









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
using formula to compare two text lists that are not alike and ma. Maggie Excel Worksheet Functions 7 April 14th 05 06:52 PM
How do I create a macro to return drop down boxes to first item i. gaalseth Excel Discussion (Misc queries) 1 April 13th 05 09:09 PM
How do I return dynamic lists? liciakay Excel Worksheet Functions 1 March 30th 05 08:22 AM
How to compare 2 lists and return un-matched? RWR Excel Worksheet Functions 1 February 15th 05 10:25 PM
How to look up and return multiple values Wendy Excel Worksheet Functions 3 November 3rd 04 04:32 PM


All times are GMT +1. The time now is 04:37 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017