|
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 |
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 |
| All times are GMT +1. The time now is 06:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com