Results 1 to 3 of 3

Thread: Lookup (?)

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Lookup (?)

    I have a master list of contract numbers in column A (>500). In column B, I have listed the names that correspond to the contracts in column A. In column C, I have a list of the contracts utilized during any given month (<100), which is a subset of the list in column A. What I would like to do is in column D, list the names of the contracts that were utilized during the month. Any ideas?
    Thanks in advance.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Something like this in D2:
    =VLOOKUP(C2,A:B,2,0)

    Copy it down the column

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Steve.

Posting Permissions

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