<div>
I think you have forgotten to post the example workbook
</div>


I think you have forgotten to post the example workbook

<div>
I apologize for taking so long to get back on here, but I had a slight issue with my router.<br />
<br />
Here's the file. &nbsp;I can either do this in LibreOffice Calc or Excel 2003, whichever is easier. <a href="https://filedb.experts-exchange.com/incoming/2011/11_w47/522922/Example1.xls" target="_blank" class="file-inline" title="Example1 (21 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Example1.xls</a>
</div>


I apologize for taking so long to get back on here, but I had a slight issue with my router.

Here's the file.  I can either do this in LibreOffice Calc or Excel 2003, whichever is easier. Example1.xls [https://filedb.experts-exchange.com/incoming/2011/11_w47/522922/Example1.xls]

Example1.xls

<div>
I just used Vlookup, but I would really like to know if there's an easier way.<br />
<br />
Thanks.
</div>


I just used Vlookup, but I would really like to know if there's an easier way.

Thanks.

<div>
This is great. &nbsp;Thanks for the excellent explanation and the help.
</div>


This is great.  Thanks for the excellent explanation and the help.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I have several dbf files (example attached) that vary in the number of rows for each, but the columns remain the same for all. &nbsp;I would like to use either Vlookup, index, or a macro to look at Column C on Sheet2 and Column C on Sheet1. &nbsp;Then whenever the values match, move Columns C through W on Sheet2 to Sheet1 beginning on Column M of Sheet1.<br />
<br />
For example, on the file provided, I would like to have Sheet2 Row 1 Columns C through W move to Sheet1 Row 11 Columns M through AG. &nbsp;<br />
<br />
Any help would be greatly appreciated. <br />
<br />
Thanks,<br />
J
</div>
</div>


Hello Experts,

I have several dbf files (example attached) that vary in the number of rows for each, but the columns remain the same for all.  I would like to use either Vlookup, index, or a macro to look at Column C on Sheet2 and Column C on Sheet1.  Then whenever the values match, move Columns C through W on Sheet2 to Sheet1 beginning on Column M of Sheet1.

For example, on the file provided, I would like to have Sheet2 Row 1 Columns C through W move to Sheet1 Row 11 Columns M through AG.  

Any help would be greatly appreciated. 

Thanks,
J

Help with vlookup in Libreoffice calc.

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

LibreOffice

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.