Excel lookup across entire workbook

[alabarghouti]

Hi,

- Workbook contains 100 sheets (one for each project)
- Each worksheet is named a unique project number (e.g. "123456"). This number is also in cell B5.
- Project "Cost" is in cell 30L in each project worksheet
- In the Summary worksheet, I have one row designated for each project, with project # in column B and vital info (i.e. Cost, Value, etc.) taken from project worksheets listed in subsequent columns.
I need to create a formula in a cell in the summary sheet that does the following:
- Matches project number in column B (different # for each row) with that in cell B5 of project worksheets, then
- Provides the "Cost" value found in cell 30L of the target worksheet

Thanks in advance!

 

[GS]

Hi,

- Workbook contains 100 sheets (one for each project)
- Each worksheet is named a unique project number (e.g. "123456").
This number is also in cell B5. - Project "Cost" is in cell 30L in
each project worksheet - In the Summary worksheet, I have one row
designated for each project, with project # in column B and vital
info (i.e. Cost, Value, etc.) taken from project worksheets listed in
subsequent columns. I need to create a formula in a cell in the
summary sheet that does the following: - Matches project number in
column B (different # for each row) with that in cell B5 of project
worksheets, then - Provides the "Cost" value found in cell 30L of the
target worksheet

Thanks in advance!

Depending on your requirements, IMO this would be a lot better
implimented using VBA (macro). Optionally, you could have a userform
with a multi-column listbox you can scroll through, that lists all the
info from each sheet.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion