Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    abudhabi, United Arab Emirates
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    HELP -VLOOKUP (EXCEL 2002)

    <P ID="nt"><font size=-1>(No Text)</font>
    Attached Files Attached Files

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

    Re: HELP -VLOOKUP (EXCEL 2002)

    This is a reaction to the first question.

    Change the number format of Required!B4 from Text to General.
    Enter the following formula in that cell:
    <pre>=SAMPLE!B4&" "&SAMPLE!C4&" "&SAMPLE!D4</pre>

    Copy down as far as needed.

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

    Re: HELP -VLOOKUP (EXCEL 2002)

    Answers to two of your questions in the attached workbook. I do not understand the third question.
    Attached Files Attached Files
    Legare Coleman

  4. #4
    New Lounger
    Join Date
    Nov 2001
    Location
    abudhabi, United Arab Emirates
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HELP -VLOOKUP (EXCEL 2002)

    pls look at attachment
    thanks
    Attached Files Attached Files
    • File Type: xls q.xls (15.0 KB, 1 views)

  5. #5
    New Lounger
    Join Date
    Nov 2001
    Location
    abudhabi, United Arab Emirates
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HELP -VLOOKUP (EXCEL 2002)

    thanks it worked
    jb

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

    Re: HELP -VLOOKUP (EXCEL 2002)

    For the description of code 11718 in cell B7 you can use the following formula in a cell:
    <pre>=A7&" "&$B$6&" "&$A$4</pre>

    and copy down as far as needed.

    The dollar signs in $B$6 and $A$4 indicate that these are absolute references - they won't change when you copy the formula down.

    Analogously, for the description of code 11730 in cell C7 you can use the following formula:
    <pre>=D7&" "&$C$6&" "&$A$4</pre>

    and copy down as far as needed.

  7. #7
    New Lounger
    Join Date
    Nov 2001
    Location
    abudhabi, United Arab Emirates
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HELP -VLOOKUP (EXCEL 2002)

    Thanks HANSV
    ur solution solved my problem & made my wrk a whole lot easier.BUT--- as usual with one problem solved another one crops up.
    to explain--- need to sort the material desc from different tables---which i've done[more than 5000 items]
    I need to export the same into another wksht to use as an Enquiry and subsequently a P.order.[will be used on 3 or 4 different stand alone computors]. do i need to make any links as they are all different work books. Is it easier for me to save the same as a template.
    thanks

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

    Re: HELP -VLOOKUP (EXCEL 2002)

    If the information is static (numbers and descriptions aren't going to change), you can replace the formulas by their values:
    <UL><LI>Select the appropriate range.
    <LI>Edit/Copy.
    <LI>If you really want to get rid of the formulas, leave the range selected. If not, select a single cell somewhere else (in the same worksheet, in another worksheet of the same workbook, or even in a different workbook). This will become the upper left corner of the pasted values.
    <LI>Edit/Paste special...
    <LI>Select Values.
    <LI>Click OK.

    If the information is not static and you want to use it in workbooks on several stand alone computers, you can copy the entire worksheet to the other workbooks. I wouldn't bother about making a template for 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
  •