find exact data in cell

[New Hope UMC]

I have a single record I am looking for based on 2 sets of criteria;
Sheet1 Cell B2, I am looking for the Building "105"
Sheet 1 Cell E2, I am looking for the Programs "2010 X-Program"
The information return would be in Sheet1 Cell F2 giving me all
projects contained in "2010 X-Program"

In Sheet 2 I have all the information
Column A contains all the buildings (3,000 buildings total) Header;
"Buildings"
Cell B1:J1 contains all the Programs; 2009 X-Program, 2010 Refit, 2010
X-Program etc...
What I need is this. In Sheet1 Cell F2 the formula would locate for
building "105" in Sheet 2 Column A and then locate "2010 X-Program"
across B1:J1, once these two are found then give me the information in
the cell where these two intersect.
I have tried index match, index match match, sumproduct etc...but I am
getting nowhere. The problem is the lookup on the multiple columns of
"Programs" I have.
Any suggestions?
Hans

 

[Dave Peterson]

You'll want to use a combination of =index() and =match().

Debra Dalgleish has lots of notes here:
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

 

[New Hope UMC]

You'll want to use a combination of =index() and =match().

Debra Dalgleish has lots of notes here:http://www.contextures.com/xlFunctions03.html (for =index(match()))
andhttp://contextures.com/xlFunctions02.html#Trouble

Dave,

Her 2nd example worked perfectly. I did it the same way (or so I
thought) but could not make it work properly. Once again Thanks!