Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Clemmons, North Carolina, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel - macro find loop (Excel 2000)

    I have two columns of numbers. (in this case two columns of Social Security Numbers). I need to go through the numbers in columns A and do a .Find on column B to see if that Social Security Number shows up somewhere in that column. I am having trouble figuring out the logic for that Do Loop. Would someone help, please?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - macro find loop (Excel 2000)

    Assuming Row 1 is the header row, in cell C2 put the formula =VLOOKUP(B2, $A:$A,1, FALSE), then double click the fill handle, you will get #N/A alongside each value in Col B that does not have a coresponding value in Col A

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Location
    Clemmons, North Carolina, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - macro find loop (Excel 2000)

    Thank you. That seemed to work just fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •