Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Location
    Taylor, Louisiana, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Measurements (Excel 2000)

    Hi, I have a report that has data imported from another location that tells me how many boards of each size they have. They data comes into my spreadsheet as a single or double digit number and each of these numbers represents a different board size. For example 2 would be for 2x6x8 and 3 would be 2x6x10. Is there a way to have my spreadsheet show the measurement instead of the single or double digit? I have access to the other computer and can change it if needed. Thank you

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Measurements (Excel 2000)

    Hi bjm,

    You could use a lookup table for this. See attached example, which has your imported data in column A, the lookup results in column B and the lookup table in columns D & E.

    Cheers
    PS: The values in Column D should be listed in ascending order.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Measurements (Excel 2000)

    You'll have to set up a table that shows the correspondence between the numbers and the measurements, for example in a separate worksheet in the workbook:

    <table border=1><tr><td align=right>1</td><td>

  4. #4
    New Lounger
    Join Date
    Nov 2003
    Location
    Taylor, Louisiana, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Measurements (Excel 2000)

    Thanks for responding, I will try it asap.

  5. #5
    New Lounger
    Join Date
    Nov 2003
    Location
    Taylor, Louisiana, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Measurements (Excel 2000)

    Thank you I will try this.

Posting Permissions

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