Vlookup with multiple criteria

[Phillycheese5]

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 broke
and grab some data for Sheet2. Here's what my dataset looks lik
(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.) bu
couldn't get it to work.
Thanks,
Phillycheese

 

[Anne Troy]

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"Phillycheese5" <[email protected]>
wrote in message
news[email protected]...