ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   worksheet (https://www.excelbanter.com/excel-worksheet-functions/7368-worksheet.html)

util

worksheet
 
How do you combine information from two worksheets..First worksheet is the
main worksheet. One field in the row determines the information to pull from
the second worksheet. If the Field idatas matches the field data in the
second worksheet...... the entire row should be linked to first worksheet row.

Frank Kabel

Hi
have a look at the VLOOKUP function. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"util" schrieb im Newsbeitrag
...
How do you combine information from two worksheets..First worksheet

is the
main worksheet. One field in the row determines the information to

pull from
the second worksheet. If the Field idatas matches the field data in

the
second worksheet...... the entire row should be linked to first

worksheet row.



All times are GMT +1. The time now is 02:36 AM.

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