Hi,
I have Sheet1 with a list of 10 investment strategies, each with 20+
brokers. Many brokers are listed in several strategies.

I'm trying to do a VLOOKUP that checks for both the strategy and broker
and grab some data for Sheet2. Here's what my dataset looks like
(abbreviated):

Large Growth - Bob (select data to the right is what I need)
Large Growth - Pete
Large Growth - Jack

Small Value - Bob
Small Value - Jack
Small Value - Mike

I tried looking at some past threads (with INDEX, MATCH, etc.) but
couldn't get it to work.
Thanks,
Phillycheese5


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=382939