# Thread: HELP -VLOOKUP (EXCEL 2002)

1. ## HELP -VLOOKUP (EXCEL 2002)

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

2. ## 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. ## Re: HELP -VLOOKUP (EXCEL 2002)

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

4. ## Re: HELP -VLOOKUP (EXCEL 2002)

pls look at attachment
thanks

5. ## Re: HELP -VLOOKUP (EXCEL 2002)

thanks it worked
jb

6. ## 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. ## 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. ## 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
•