ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I set up an Excel worksheet that compiles data from other . (https://www.excelbanter.com/excel-worksheet-functions/18296-how-do-i-set-up-excel-worksheet-compiles-data-other.html)

BeginnerExceluser

How do I set up an Excel worksheet that compiles data from other .
 
How do I set up an Excel worksheet that compiles data from other Excel
worksheets. If the directions are too lengthy what is the proper Search Term
to use?

Jose366

Try VLookup or HLookup. If you have a "main" table with a common field to
the other tables these should work well for you.

"BeginnerExceluser" wrote:

How do I set up an Excel worksheet that compiles data from other Excel
worksheets. If the directions are too lengthy what is the proper Search Term
to use?



All times are GMT +1. The time now is 04:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com