You can do a vlookup with concatenated text, i.e.,
=vlookup(a1&b1,range,column)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Phillycheese5"
wrote in message
news:Phillycheese5.1rcuaj_1119992754.4048@excelfor um-nospam.com...

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