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 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

[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]...
>
> 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
>

[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]...
>
> 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
>

[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]...
>
> 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
>

[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]...
>
> 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
>

[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]...
>
> 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
>

[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]...
>
> 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
>

[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]...
>
> 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
>

[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]...
>
> 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
>

[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]...
>
> 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
>

[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]...
>
> 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
>

[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]...
>
> 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
>

[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]...
>
> 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
>