Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell Referencing (xls 97)

    I have linked one worksheet that contains job ID#'s to an identical worksheet within the file. I want the linked (2nd) sheet to then take the ID# and display the correspoding job title for that number.

    So if sheet1 looks like this:
    Date
    Employee (123)

    Sheet 2 should be:
    Date
    Employee (Project proposal for audit)

    ***** minus the ().********

    Any help would be greatly appreciated.......

    Thanks!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Referencing (xls 97)

    Your description was a little sparse on information. Is the (123) the ID number? Is it in a cell by itself? With or without the parenthesis?

    Guessing the answer to the above questions, I think that what you need to do is set up a table of ID#s and Titles (probably on another sheet) that looks like this:

    <pre>123 Project 123
    456 Project 456
    789 Project 789
    </pre>


    Then use the VLOOKUP function to look the ID# up in the table and return the Title.
    Legare Coleman

Posting Permissions

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