LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SBB
 
Posts: n/a
Default Can I use a lookup function that pulls referenced cells in multip.

Example: I have a lookup reference in cell A1. I have created a single
sheet to pull in data from cell B2 when it sees the corresponding A1 lookup.
There are 100 sheets with the individual information and I want to display
the information in a column on this separate sheet by creating a list of all
of teh A1s that appear for each page. Is there a formaula that can pull this
information and match it to a list that I have generated on a separate page?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Count blank cells containing function IntricateFool Excel Discussion (Misc queries) 3 June 10th 06 12:44 AM
Lookup function help marlea Excel Worksheet Functions 4 August 30th 05 08:11 PM
Lookup Function help marlea Excel Discussion (Misc queries) 2 August 23rd 05 07:30 PM
Lookup function problem (kg) greencecil Excel Worksheet Functions 3 July 1st 05 04:54 PM
Lookup formula - treat no-registered cells as blank gublues Excel Worksheet Functions 4 June 13th 05 10:32 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"