ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help With Formula (https://www.excelbanter.com/excel-discussion-misc-queries/174823-help-formula.html)

A. J. Walewski

Help With Formula
 
I'm working on a workbook and need some help writting a formula. The workbook
wil have 6 sheets. Five sheets will be labeled with dates (May 31...). the
last sheet will be labeled Summary. I'm looking for a way to match a name on
the summary sheet to data that is attached to the name on the monthly sheets
and place the data in cells on the summary sheet. The name and data (not in
the same cell) will appear in the same columns of the monthly sheets but not
in the same rows.

Thanks
AJ

[email protected]

Help With Formula
 
hello,

hint : you should have a look to the function INDIRECT which do the
job (as far as I've well understood your need).

Mat


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

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