Posted to microsoft.public.excel.worksheet.functions

LRM

external usenet poster

Posts: 2

lookup and worksheet name and then do formula

I have multiple worksheets named after customers...say "BW", "CAR", etc.
In the first summary worksheet I want to input formulas to grab info from
the correct worksheet. In other words, I want the formula in A2 to search
for a name in cell A1 that corresponds with the worksheet and then pull info
from a specific cell in that worksheet.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel worksheet lookup	sleddude	Excel Discussion (Misc queries)	1	October 8th 08 07:48 PM
Formula to lookup worksheet label	Grotejm	Excel Worksheet Functions	3	April 3rd 08 05:16 AM
lookup for worksheet	Bradrok	Excel Worksheet Functions	1	April 2nd 08 11:04 PM
Worksheet lookup	Greg B	Excel Discussion (Misc queries)	2	August 4th 05 12:47 PM
formula to lookup table in another Worksheet please	Steved	Excel Worksheet Functions	1	June 14th 05 10:39 AM

All times are GMT +1. The time now is 03:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us