Can I use a lookup function that pulls referenced cells in multip.

S

SBB

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup or search using the * character 1
Page numbering with Merged Document and IF statements 1
Lookup functions always return n/a ??? 3
Function to pull a single cell from a column into another cell 1
Switch lookup function to another sheet 2
use cell text in lookup function 3
lookup cell reference and copy contents and comment from a range 0
How can I do a lookup to a specific cell on another tab 1

Top