christianna,

You may be able to use User Defined Function VLookupNth, or and array formula.

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples directly in the forum.

Please attach screenshots of your workbook or a sample workbook that accurately portrays your current workbook on one sheet, and what it should look like 'After' on another sheet.

This makes it much easier to see exactly what you want to do, as well as shows us whether there is a consistent number of rows between tables and such.

Here are three possible ways to post small (copyable) screen shots directly in your post:

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).

http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

or

http://RichardSchollar’s beta HTML M...om of his post

or

Borders-Copy-Paste

Or, you can upload your workbook to www.box.net andprovide us with a link to your workbook.

## Like this thread? Share it with others