Results 1 to 4 of 4

VLookup help...PLEASE

Threaded View

KatherineRebecc VLookup help...PLEASE 02-23-2007, 04:55 PM
oldchippy Are you saying, B2 needs to... 02-23-2007, 05:10 PM
KatherineRebecc Thanks but it doesnt help.... 02-23-2007, 05:24 PM
oldchippy Does this help? 02-23-2007, 05:42 PM
  1. 02-23-2007, 04:55 PM #1
    KatherineRebecc is offline
    Registered User
    Join Date
    02-23-2007
    Posts
    2

    VLookup help...PLEASE

    I need help. I have a spreadsheet where in column A I have lawsuit numbers. Some of the numbers are repeated several times. In column B I have dates. Not all the cells in column B are filled in. I am trying to figure out if there is a way where I can do vlookup for the dates instead of doing each one separate.
    Example
    A1 is case #111 B1 is 1999
    A2 is case #111 B2 is blank
    A3 is case #200 B3 is 2004
    A4 is case #200 B4 is blank
    A5 is case #200 B5 is blank
    A6 is case #300 B6 is 1999

    I have all the case numbers and the dates on another page in my workbook where they (the case numbers) are only listed once.

    Is there anything I can do to make this much easier on me?
    Thanks in advance for any help, Katherine
    Last edited by KatherineRebecc; 02-23-2007 at 05:11 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1