Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup with multiple criteria
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with a vLookup, multiple criteria | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
VlookUp with Multiple Criteria? | Excel Worksheet Functions | |||
Multiple Vlookup? | Excel Worksheet Functions |